How to generate the "create table" sql statement for an existing table in postgreSQL

Question

I have created a table in postgreSQL. I want to look at the SQL statement used to create the table but cannot figure it out.

How do I get the create table SQL statement for an existing table in Postgres via commandline or SQL statement?

question from:https://stackoverflow.com/questions/65945569/psycopg2-how-to-copy-table-structureddl-to-file-for-further-recreating-table

Answer 1

pg_dump -t 'schema-name.table-name' --schema-only database-name

More info - in the manual.