Horton

Re: Grant / Revoke functionality

Shridhar Daithankar <shridhar_daithankar@persistent.co.in>

View thread View on postgr.es
From: Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
To: Alexander Priem <ap@cict.nl>
Cc: pgsql-general@postgresql.org
Date: 2004-02-18T09:37:14Z
Lists: pgsql-general 
On Wednesday 18 February 2004 14:41, Alexander Priem wrote:
> Thanks for your reply.
>
> I already have all the tables/views/sequences set up and filled. Can I
> create a new schema and 'assign' the existing tables/views/sequences to
> this new schema? Will this affect current queries I have created?

You mean alter table set schema to foo? I doubt you can do that..

What you can do is dump/reload a single schema. After dumping the schema, edit 
the dump to schema creation/set search path by hand and it will insert the 
objects in the new schema..

HTH

 Shridhar