From: | Dennis Gearon <gearond(at)cvc(dot)net> |
---|---|
To: | Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> |
Cc: | Yudha Setiawan <inas_husband(at)bonbon(dot)net>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Dump Customizing |
Date: | 2003-08-05 16:04:14 |
Message-ID: | 3F2FD57E.1040107@cvc.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Amin Abdulghani | 2003-08-05 16:10:31 | Could not receive data from server |
Previous Message | Stephan Szabo | 2003-08-05 15:49:36 | Re: Dump Customizing |