How start using schemas for existing database

From: "Berend Tober" <btober(at)seaworthysys(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: How start using schemas for existing database
Date: 2003-02-05 17:15:07
Message-ID: 64793.216.238.112.88.1044465307.squirrel@$HOSTNAME
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

So I'm convinced that using the new support for multiple schemas in a database
is a good thing. I've got a database with scores of tables currently residing
within the public schema. I've decided which tables I want to put in
application-specific schemas and which to leave in public or maybe put in some
shared schema created for that purpose of being used by mulitple applications.

What is a good, efficient way to get the tables distributed into the schemas?
It would be too good to be true if I could simply drag and drop tables into
new schemas using pgAdminII, but think that is not possible.

Do I have to do a pg_dump, and then edit the resulting script manually to
prepend table names with the intended schema name? How about all the related
indexes and relational integrity triggers? Manually editing the script file
for a large database seems like a process doomed to introduce many
opportunities for errors. What is the best way to handle this?

Regards,
Berend Tober

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2003-02-05 17:15:13 Re: Question: unique on multiple columns
Previous Message Bruno Wolff III 2003-02-05 16:53:09 Re: Question: unique on multiple columns