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
>