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@xxxxxxxxxx - 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
