| From: | Shridhar Daithankar <shridhar_daithankar(at)persistent(dot)co(dot)in> |
|---|---|
| To: | Alexander Priem <ap(at)cict(dot)nl> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Grant / Revoke functionality |
| Date: | 2004-02-18 09:37:14 |
| Message-ID: | 200402181507.14703.shridhar_daithankar@persistent.co.in |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2004-02-18 09:54:48 | Re: Grant / Revoke functionality |
| Previous Message | pativo | 2004-02-18 09:17:01 | Re: String manipulation |