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
-- 
[EMAIL PROTECTED] - 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

Reply via email to