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