A nice addition to the dump commands would be something like:

-scope( schema( schema_s), tables( table_1), dbases_name objects( tables, indexes, constraints, types, functions, triggers, data, etc) )

if it could be completely hierarchial, then any set of objects desired could be extracted.



Stephan Szabo wrote:

On Tue, 5 Aug 2003, Yudha Setiawan wrote:


Dear expert,

It's Urgent.....
How do I dump just for
   - Table Structure
   - Index
   - Constraint
   - Type
   - Function.
Without
   - Create Trigger.
   - Data.
i've tried with -X option, but it didn't works
"pg_dump -Upostgres test_yudha1 -fyudha1 -v -s -R -X disable-triggers;"
Thank's for your attention.


I don't think there is one that'll drop the create trigger statements
so you'll probably need to do some post-processing on a schema only dump
to get it.



---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster



---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to