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. LIKE vs CONTAINS on SQL Server
  23. What’s the best way to search for a UPC code in a Database?
  24. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  25. What is the difference between “INNER JOIN” and “OUTER JOIN”?
  26. What is the difference between “INNER JOIN” and “OUTER JOIN”?
  27. What is an MDF file? [closed]
  28. What is the difference between UNION and UNION ALL?
  29. Selecting COUNT(*) with DISTINCT
  30. Case in Select Statement
  31. What is a stored procedure?
  32. What is the difference between varchar and nvarchar?
  33. ORA-00904: invalid identifier
  34. SQL WITH clause example [duplicate]
  35. Unknown column in ‘field list’ error on MySQL Update query
  36. Unknown column in ‘field list’ error on MySQL Update query
  37. SQL Inner-join with 3 tables?
  38. The wait operation timed out. ASP
  39. What is SELF JOIN and when would you use it? [duplicate]
  40. The wait operation timed out. ASP
  41. Conversion failed when converting date and/or time from character string while inserting datetime
  42. Self Join to get employee manager name
  43. How do I UPDATE from a SELECT in SQL Server?
  44. how to fix oracle ORA-01722 invalid number error
  45. SQL query to select dates between two dates
  46. Turn off pager for psql’s interactive output
  47. MySQL – Operand should contain 1 column(s)
  48. SQL SELECT WHERE field contains words
  49. Conversion failed when converting date and/or time from character string while inserting datetime
  50. When should I use CROSS APPLY over INNER JOIN?
  51. MySQL “CREATE TABLE IF NOT EXISTS” -> Error 1050
  52. PostgreSQL: Show tables in PostgreSQL
  53. Insert Data Into Temp Table with Query
  54. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  55. What is this JavaScript “require”?
  56. MySQL create table if not exists and insert record only if table was created
  57. error, string or binary data would be truncated when trying to insert
  58. How to create Temp table with SELECT * INTO tempTable FROM CTE Query
  59. NOT IN vs NOT EXISTS
  60. SQL SELECT WHERE field contains words
  61. Online SQL Query Syntax Checker
  62. How can I do an UPDATE statement with JOIN in SQL Server?
  63. Must declare the scalar variable
  64. What is this JavaScript “require”?
  65. How do I use MySQL through XAMPP?
  66. ORA-00979 not a group by expression
  67. ORA-00907: missing right parenthesis
  68. How do I use properly CASE..WHEN in MySQL
  69. Must declare the scalar variable
  70. Rename column SQL Server 2008
  71. Why do we need “Relationships” between tables at all?
  72. INSERT statement conflicted with the FOREIGN KEY constraint – SQL Server
  73. Using group by on multiple columns
  74. Efficiently convert rows to columns in sql server
  75. How can I do a FULL OUTER JOIN in MySQL?
  76. Nested select statement in SQL Server
  77. INSERT statement conflicted with the FOREIGN KEY constraint – SQL Server
  78. Using group by on multiple columns
  79. SQL SELECT WHERE field contains words
  80. Psql could not connect to server: No such file or directory, 5432 error?
  81. MySQL query String contains
  82. How do I escape a single quote in SQL Server?
  83. What’s the difference between VARCHAR and CHAR?
  84. Case statement in MySQL
  85. IDENTITY_INSERT is set to OFF – How to turn it ON?
  86. T-SQL split string based on delimiter
  87. How to declare a variable in MySQL?
  88. How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
  89. Finding duplicate values in a SQL table
  90. ORA-01843 not a valid month- Comparing Dates
  91. SqlException: DB2 SQL error: SQLCODE: -302, SQLSTATE: 22001, SQLERRMC: null
  92. How to rename a table in SQL Server?
  93. MySQL Cannot Add Foreign Key Constraint
  94. Drop a temporary table if it exists
  95. How do I escape a single quote in SQL Server?
  96. ORA-00918: column ambiguously defined in SELECT *
  97. Teradata: how to convert varchar value (format ‘dd.mm.yyyy’) to date (format ‘yyyy-mm-dd’ )?
  98. How Stuff and ‘For Xml Path’ work in SQL Server?
  99. IDENTITY_INSERT is set to OFF – How to turn it ON?
  100. Oracle error : ORA-00905: Missing keyword

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)