An easy method of moving the tables are
create table mynewschema1.table1 as select * from public.table1; drop public.table1;
create table mynewschema2.table2as select * from public.table2; drop public.table2;
You may need to recreate any indexes that the tables used in the public schema, and you may need to grant rights in order to allow your users to access the tables...
Hope that helps
John Sidney-Woollett
create
[EMAIL PROTECTED] wrote:
Hi,
In my database, I created a lot of tables before I found out about schemas. It's a mess!
Suppose I want to get organised, and create a couple of schemas. How do I move existing tables into my newly created schemas?
e.g.
public.table1 -> mynewschema1.table1 public.table2 -> mynewschema2.table2
?
Thanks.
Max
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
