Show table definition
suggest changeOpen the psql
command line tool connected to the database where your table is. Then type the following command:
\d tablename
To get extended information type
\d+ tablename
If you have forgotten the name of the table, just type \d into psql to obtain a list of tables and views in the current database.
Found a mistake? Have a question or improvement idea?
Let me know.
Table Of Contents