Re: 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-admin(at)postgresql(dot)org
Subject: Re: dumping tables in non-public schemas..
Date: 2002-12-20 14:29:00
Message-ID: 20021220232713.1D48.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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Bruce Momjian 2002-12-20 17:41:52 Re: dumping tables in non-public schemas..
Previous Message Masaru Sugawara 2002-12-20 12:25:02 Re: [ADMIN] dumping tables in non-public schemas..

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-12-20 15:03:19 Re: Unable to format timestamp with time zone; internal coding error
Previous Message Vegard Munthe 2002-12-20 12:38:42 Problems with lower('Å')