-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]