Dump DDL for all schema in your database to a file in Greenplum

Post date: Oct 30, 2014 5:20:7 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