www.dbaref.com
Home
Oracle
PostgreSQL
Greenplum MPP Database
MongoDB
Docker Platform
Flocker
Mesos cluster management
Tableau
Our GitHub
MJB e-Services
Amazon Books
LIABILITY DISCLAIMER
Greenplum DBA LinkedIn Group
Oracle DBA Quick References
Top 20 Unix Commands
Top 20 SQL Scripts
Top 20 Vi Commands
Top 20 v$ views
Tracing SQL
Tracing Sessions
Unix Scripts for Oracle DBA's
Oracle 11g New Features
Oracle Performance Tuning
SQL Scripts for Oracle DBA's
UNIX and Linux for Oracle DBA
VI Editor Commands
Windows OS and Oracle DBA
Cron Jobs
Unix File Management
DBA Tips and Tricks
Greenplum
PostgreSQL Quick Ref
PG/PSQL Quick Re
f
Find command in Unix
greenplum-database-dba-references
>
Get DDL for all schema in your database in Greenplum
posted
Apr 28, 2017, 10:29 AM
by Sachchida Ojha
$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
Comments
