dumping tables in non-public schemas..

On Fri, 20 Dec 2002 12:00:47 +0530
"Rajesh Kumar Mallah." <mallah@trade-india.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

On Fri, 20 Dec 2002 12:00:47 +0530
"Rajesh Kumar Mallah." <mallah@trade-india.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

Masaru Sugawara wrote:

On Fri, 20 Dec 2002 12:00:47 +0530
"Rajesh Kumar Mallah." <mallah@trade-india.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

Yes, it is on the TODO list.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

On Fri, 20 Dec 2002 12:41:52 -0500 (EST)
Bruce Momjian <pgman@candle.pha.pa.us> wrote:

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

pg_dump -t schema.* database_name

Yes, it is on the TODO list.

That's great news !

Regards,
Masaru Sugawara