dumping tables in non-public schemas..

Поиск
Список
Период
Сортировка
Искать

dumping tables in non-public schemas..

От:
"Rajesh Kumar Mallah." <mallah@trade-india.com>
Дата:

HI,

How do we dump a particular schema qualified table using pg_dump?
pg_dump -t shema.tablename database_name 

does not seems to work

regds
mallah.


-- 
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)

Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.


Re: dumping tables in non-public schemas..

От:
Masaru Sugawara <rk73@sea.plala.or.jp>
Дата:
On Fri, 20 Dec 2002 12:00:47 +0530
"Rajesh Kumar Mallah."  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


Re: dumping tables in non-public schemas..

От:
Bruce Momjian <pgman@candle.pha.pa.us>
Дата:
Masaru Sugawara wrote:
> On Fri, 20 Dec 2002 12:00:47 +0530
> "Rajesh Kumar Mallah."  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

Re: dumping tables in non-public schemas..

От:
Masaru Sugawara <rk73@sea.plala.or.jp>
Дата:
On Fri, 20 Dec 2002 12:41:52 -0500 (EST)
Bruce Momjian  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


FAQ