Moving tables between schemas

From: "m(dot)e(dot)bruche(at)lse(dot)ac(dot)uk" <m(dot)e(dot)bruche(at)lse(dot)ac(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: Moving tables between schemas
Date: 2004-07-30 10:26:58
Message-ID: 1091183218.7080.14.camel@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John Sidney-Woollett 2004-07-30 10:42:58 Re: Moving tables between schemas
Previous Message John Sidney-Woollett 2004-07-30 10:19:55 Re: Moving tables between schemas