[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,
[hidden email] - tel: - fax:

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