pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

Re: Rename Schema or Script DDL only a schema
2+ messages / 2 participants
[nested] [flat]

* Re: Rename Schema or Script DDL only a schema
@ 2004-04-06 08:17  Olivier Hubaut <olivier@scmbb.ulb.ac.be>
  parent: kumar <sgnerd@yahoo.com.sg>
  0 siblings, 0 replies; 2+ messages in thread

From: Olivier Hubaut @ 2004-04-06 08:17 UTC (permalink / raw)
  To: kumar <sgnerd@yahoo.com.sg>; pgsql-sql

On Tue, 6 Apr 2004 14:32:04 +0530, kumar <sgnerd@yahoo.com.sg> wrote:

> Dear Friends,
>
> Postgres 7.3.2 on Linux 8.
>
> I wanna move about 100 tables from one schema to another (within a  
> database). Is possible to do that? Seems pg_dump doesnt have an option  
> to script only the schema.
>
> Else, it possible to rename the schema.
>
> Please shed some light.
>
> Thanks
> Kumar

Not with this version of PG.
v7.4 allows you to rename schema and dump specific schemas.



-- 
Downloading signature ... 99%
*CRC FAILED*
signature aborted



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Rename Schema or Script DDL only a schema
@ 2004-04-06 09:02  kumar <sgnerd@yahoo.com.sg>
  0 siblings, 1 reply; 2+ messages in thread

From: kumar @ 2004-04-06 09:02 UTC (permalink / raw)
  To: pgsql-sql

Dear Friends,

Postgres 7.3.2 on Linux 8.

I wanna move about 100 tables from one schema to another (within a database). Is possible to do that? Seems pg_dump doesnt have an option to script only the schema.

Else, it possible to rename the schema.

Please shed some light.

Thanks
Kumar

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2004-04-06 09:02 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-04-06 09:02 Rename Schema or Script DDL only a schema kumar <sgnerd@yahoo.com.sg>
2004-04-06 08:17 ` Olivier Hubaut <olivier@scmbb.ulb.ac.be>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox