PostgreSQL “DESCRIBE TABLE”

Try this (in the psql command-line tool):

\d+ tablename

See the manual for more info.

Related Posts:

  1. missing FROM-clause entry for table
  2. PostgreSQL: Remotely connecting to Postgres instance using psql command
  3. Insert text with single quotes in PostgreSQL
  4. ERROR: there is no unique constraint matching given keys for referenced table “bar”
  5. Postgresql: Scripting psql execution with password
  6. “psql: could not connect to server: Connection refused” Error when connecting to remote database
  7. Simulate CREATE DATABASE IF NOT EXISTS for PostgreSQL?
  8. Postgresql tables exists, but getting “relation does not exist” when querying
  9. postgresql: error duplicate key value violates unique constraint
  10. psql: command not found Mac
  11. pg_ctl: no database directory specified and environment variable PGDATA unset
  12. Postgres Error: More than one row returned by a subquery used as an expression
  13. How to exit from PostgreSQL command line utility: psql
  14. What is the difference between LATERAL JOIN and a subquery in PostgreSQL?
  15. psql: FATAL: database “” does not exist
  16. PostgreSQL create table if not exists
  17. updating table rows in postgres using subquery
  18. PostgreSQL visual interface similar to phpMyAdmin?
  19. GROUP BY and COUNT using ActiveRecord
  20. Postgresql column reference “id” is ambiguous
  21. What is a postgres superuser
  22. What is a stored procedure?
  23. Unknown column in ‘field list’ error on MySQL Update query
  24. SQL Inner-join with 3 tables?
  25. Conversion failed when converting date and/or time from character string while inserting datetime
  26. error, string or binary data would be truncated when trying to insert
  27. Why do we need “Relationships” between tables at all?
  28. INSERT statement conflicted with the FOREIGN KEY constraint – SQL Server
  29. SQL SELECT WHERE field contains words
  30. Psql could not connect to server: No such file or directory, 5432 error?
  31. Case statement in MySQL
  32. IDENTITY_INSERT is set to OFF – How to turn it ON?
  33. Teradata: how to convert varchar value (format ‘dd.mm.yyyy’) to date (format ‘yyyy-mm-dd’ )?
  34. How Stuff and ‘For Xml Path’ work in SQL Server?
  35. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
  36. How do I limit the number of rows returned by an Oracle query after ordering?
  37. Oracle SELECT TOP 10 records
  38. Getting error: Peer authentication failed for user “postgres”, when trying to get pgsql working with rails
  39. MySQL: Invalid use of group function
  40. must appear in the GROUP BY clause or be used in an aggregate function
  41. Import / Export database with SQL Server Server Management Studio
  42. How can I return pivot table output in MySQL?
  43. The multi-part identifier could not be bound
  44. MySQL syntax for Join Update
  45. incorrect syntax error CREATE VIEW must be the only statement in the batch
  46. PLS-00103: Encountered the symbol when expecting one of the following:
  47. SQLite – UPSERT *not* INSERT or REPLACE
  48. Attach (open) mdf file database with SQL Server Management Studio
  49. how to drop partition without dropping data in MySQL?
  50. PSQLException: current transaction is aborted, commands ignored until end of transaction block
  51. psql: FATAL: Ident authentication failed for user “postgres”
  52. Simple way to calculate median with MySQL
  53. The ALTER TABLE statement conflicted with the FOREIGN KEY constraint
  54. Error 1046 No database Selected, how to resolve?
  55. What is it exactly a BLOB in a DBMS context
  56. Simple Random Samples from a Sql database
  57. How do you create a temporary table in an Oracle database?
  58. Oracle SQL: Update a table with data from another table
  59. How do you create a yes/no boolean field in SQL server?
  60. postgresql duplicate key violates unique constraint
  61. could not connect to server: No such file or directory (PG::ConnectionBad)
  62. How to change PostgreSQL user password?
  63. SELECT DISTINCT on one column
  64. TSQL PIVOT MULTIPLE COLUMNS
  65. MySQL – UPDATE multiple rows with different values in one query
  66. How to create a MySQL hierarchical recursive query?
  67. Microsoft OLE DB Provider for SQL Server error ‘80004005’
  68. Equivalent of Oracle’s RowID in SQL Server
  69. Is there a Max function in SQL Server that takes two values like Math.Max in .NET?
  70. Best way to test if a row exists in a MySQL table
  71. Subtract one day from datetime
  72. Get current year in TSQL
  73. Is it possible to specify condition in Count()?
  74. Backup a single table with its data from a database in sql server 2008
  75. How to do Select All(*) in linq to sql
  76. MySQL OPTIMIZE all tables?
  77. MySQL INSERT INTO table VALUES.. vs INSERT INTO table SET
  78. Is there a coalesce-like function in Excel?
  79. What datatype should be used for storing phone numbers in SQL Server 2005?
  80. Postgres: INSERT if does not exist already
  81. PHP Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /home/website/public_html/facebook/fbclogin.php on line 57 [duplicate]
  82. How do I count unique items in field in Access query?
  83. MySQL LIKE IN()?
  84. Filter data based on date in sql
  85. ora-06553 pls-306 wrong number or types of arguments in call to ‘ogc_x’
  86. SQL query to extract only the “current” wp_posts?
  87. How to retrieve sticky post in raw sql?
  88. How to remove in the wordpress database all posts revisions except the last three?
  89. Backticks (`) Instead of Single Quotes (‘) in an SQL Statement?
  90. $wpdb get_var issue
  91. Inserting rows into a custom table, when plugin is activated
  92. Posts modified in the last 48 hours
  93. post id not displaying
  94. Insert multiple checkbox values
  95. How to get EVENT based on startday, using BETWEEN
  96. How to get the sum of each post with the same date
  97. How to dump a Microsoft SQL Server database to a SQL script?
  98. Postgresql: what does GRANT ALL PRIVILEGES ON DATABASE do?
  99. Postgres equivalent to MySQL’s \G?
  100. Postgres equivalent to MySQL’s \G?

Leave a Comment