Extracting DDL of Objects in PostgreSQL(get table ddl in PostgreSQL)

Extracting DDL of Objects in PostgreSQL(get table ddl in PostgreSQL)

===================================================

2 Ways to get DDL of objects in PostgreSQL

1. The utility pg_dump is used to dump the DDL.

2. Can get the DDL just by running \d.

1. The utility pg_dump is used to dump the DDL.

Table ddl for testtable from TESTDB

$ pg_dump -d TESTDB -s -t testtable

Table ddl for testtable from TESTDB written in to file ddl.sql

$ pg_dump -d TESTDB -s -T testtable -f ddl.sql

Table ddls for all ables from from TESTDB

$ pg_dump -d TESTDB -s

2. Can get the DDL just by running \d.

TESTDB=# \d+ testtable