Re: SCHEMA's the easy way?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: cgg007(at)yahoo(dot)com
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: SCHEMA's the easy way?
Date: 2004-05-19 17:00:12
Message-ID: 18195.1084986012@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Chris Gamache <cgg007(at)yahoo(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Martin Knipper 2004-05-19 17:09:35 Re: Function valid only for one table
Previous Message Chris Gamache 2004-05-19 16:38:32 SCHEMA's the easy way?