Thanks. I hadn't thought of that - that's probably easiest. On Fri, 2004-07-30 at 10:19, John Sidney-Woollett wrote: > You may be able to play around with the system catalogs, but I don't > know anything about that... > > 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 4: Don't 'kill -9' the postmaster
