Hi, I'm trying alter a table schema on 'PostgreSQL 8.0.2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.5 (Debian 1:3.3.5-5)'. On 8.1, by documentation, has the commant "ALTER TABLE <table> SET SCHEMA <new_schema>". Any solution for this in 8.0?
Ps.: solutions different of "CREATE TABLE <new_schema.table> as SELECT * FROM schema.table" please.