Postgres Pro
Downloads
Home   >   mailing lists

Re: SCHEMA's the easy way? - Mailing list pgsql-sql

From Tom Lane
Subject Re: SCHEMA's the easy way?
Date
Msg-id 18195.1084986012@sss.pgh.pa.us
Whole thread Raw
In response to SCHEMA's the easy way?  (Chris Gamache <cgg007@yahoo.com>)
List pgsql-sql
Tree view 
Chris Gamache <cgg007@yahoo.com> writes:
> I'm planning on dipping my toes into the world of schemata. I have tables,
> created in the Public schema, that I'd like to move to the new schema:
> Is there an easier, faster, less user-error-prone way around this? 

pg_dump, edit the "set search_path" commands in the dump script, reload.
        regards, tom lane

pgsql-sql by date:

Previous
From: Chris Gamache
Date:
Subject: SCHEMA's the easy way?
Next
From: Martin Knipper
Date:
Subject: Re: Function valid only for one table