Re: Dump Customizing

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
>