Re: Dump Customizing - Mailing list pgsql-general

From Stephan Szabo
Subject Re: Dump Customizing
Date
Msg-id 20030805084754.Q60018-100000@megazone.bigpanda.com
Whole thread Raw
In response to Dump Customizing  ("Yudha Setiawan" <inas_husband@bonbon.net>)
Responses Re: Dump Customizing  (Dennis Gearon <gearond@cvc.net>)
List pgsql-general
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.



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: like performance w/o wildcards.
Next
From: Dennis Gearon
Date:
Subject: Re: Dump Customizing