Get DDL for all schema in your database in Greenplum

Post date: Oct 30, 2014 12:14:46 PM

$pg_dump -s  -c  sachi

where sachi is the database name.

You can redirect it to a file 

$pg_dump -s  -c  sachi>>ddl_sachi.sql