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:

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.