Thread: Dump Customizing

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.

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
>

Dear Szabo you're wrote;
> 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.
----------------------------------------------------------------------------
--
Dear Dennis Gearon you're wrote;
> -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.
----------------------------------------------------------------------------
--
Thank's for your attention. And i agree with Dennis idea, that would be a
good. At least we could dump with "without" objects.

GOD Bless You All.