[GENERAL] Schemas - alter table

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[GENERAL] Schemas - alter table

David Pradier
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
--
[hidden email] - tel: 01.46.47.21.33 - fax: 01.46.47.21.37

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

               http://archives.postgresql.org