View Single Post

   
  #1 (permalink)  
Old 04-09-2008, 07:13 AM
=?ISO-8859-1?Q?William_Leite_Ara=FAjo?=
 
Posts: n/a
Default alter table schema on 8.0.X

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.

--
William Leite Araújo

Reply With Quote