Re: [ADMIN] dumping tables in non-public schemas..

From: Masaru Sugawara <rk73(at)sea(dot)plala(dot)or(dot)jp>
To: "Rajesh Kumar Mallah(dot)" <mallah(at)trade-india(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [ADMIN] dumping tables in non-public schemas..
Date: 2002-12-20 12:25:02
Message-ID: 20021220203229.1D3C.RK73@sea.plala.or.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

On Fri, 20 Dec 2002 12:00:47 +0530
"Rajesh Kumar Mallah." <mallah(at)trade-india(dot)com> wrote:

> How do we dump a particular schema qualified table using pg_dump?
> pg_dump -t shema.tablename database_name
>
> does not seems to work

In the present, there seems to be no way to do. Pg_dump will come
to output tables every schema in the future version(7.3.x or later),
I guess.

I also expect that pg_dump/pg_dumpall will have a syntax like:

pg_dump -t schema.* database_name

Regards,
Masaru Sugawara

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Masaru Sugawara 2002-12-20 14:29:00 Re: dumping tables in non-public schemas..
Previous Message Rajesh Kumar Mallah. 2002-12-20 06:30:47 dumping tables in non-public schemas..

Browse pgsql-general by date

  From Date Subject
Next Message Vegard Munthe 2002-12-20 12:38:42 Problems with lower('Å')
Previous Message Madhavi 2002-12-20 12:20:37 drop foreign key