Re: Dump Customizing

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: Yudha Setiawan <inas_husband(at)bonbon(dot)net>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Dump Customizing
Date: 2003-08-05 15:49:36
Message-ID: 20030805084754.Q60018-100000@megazone.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dennis Gearon 2003-08-05 16:04:14 Re: Dump Customizing
Previous Message Jean-Luc Lachance 2003-08-05 15:28:27 Re: Monthly table partitioning for fast purges?