Thread: dumping tables in non-public schemas..
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.
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