How to view a table's CREATE TABLE statement in PostgreSQL

To get the CREATE TABLE statement of an existing table in PostgreSQL, you can use the command line tool pg_dump:

pg_dump -t '<table_name>' --schema-only <database_name>


pg_dump -t 'users' --schema-only my_database

Get started with DB Pilot

Download DB Pilot, the database GUI with a twist.
Speed up your SQL workflows today.