Moving tables between schemas - Mailing list pgsql-general

From m.e.bruche@lse.ac.uk
Subject Moving tables between schemas
Date
Msg-id 1091183218.7080.14.camel@localhost
Whole thread Raw
Responses Re: Moving tables between schemas  (Shridhar Daithankar <shridhar@frodo.hserus.net>)
Re: Moving tables between schemas  (John Sidney-Woollett <johnsw@wardbrook.com>)
List 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


pgsql-general by date:

Previous
From: Oliver Elphick
Date:
Subject: Re: Using view
Next
From: Nilabhra Banerjee
Date:
Subject: Postgresql and OS cluster