Schemas - alter table

From: David Pradier <dpradier(at)apartia(dot)fr>
To: pgsql-general(at)postgresql(dot)org
Subject: Schemas - alter table
Date: 2005-05-20 13:26:45
Message-ID: 20050520132645.GA8776@apartia.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi everybody,

i'm looking for the way to change the schema of a table.
I've lots of tables (400), each of these being on the public schema, and,
willing to organize this a little bit, i'd like to use some schemas (20).

But i seem to be unable to find this in the documentation ; is there a
command like "alter table my_table alter schema rename my_old_schema to
my_new_schema" ?

I'd appreciate any input.

Best regards,
David
--
dpradier(at)apartia(dot)fr - tel: 01.46.47.21.33 - fax: 01.46.47.21.37

Browse pgsql-general by date

  From Date Subject
Next Message Klimenkov Vitaliy 2005-05-20 13:34:24 Error during install on WinXP
Previous Message JC 2005-05-20 13:25:58 problems with Win 2000