How To Generate Ddl For A Table?

1.	How To Generate Ddl For A Table?
Answer» Use pg_dump utility to generate DDL. EXAMPLE: pg_dump -t njonna.accounts -s -F ddl_accounts.sql Where: -f ddl_accounts.sql is OUTPUT file. -t njonna.accounts is table name with schema njonna. -s DUMP only schema no data Use pg_dump utility to generate DDL. Example: pg_dump -t njonna.accounts -s -f ddl_accounts.sql Where:

Answer»

Use pg_dump utility to generate DDL.

pg_dump -t njonna.accounts -s -F ddl_accounts.sql

Where:

Use pg_dump utility to generate DDL.

Example:

pg_dump -t njonna.accounts -s -f ddl_accounts.sql

Where:

Discussion