alter table schema on 8.0.X

From: William Leite Araújo <william(dot)bh(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: alter table schema on 8.0.X
Date: 2005-12-01 12:25:48
Message-ID: bc63ad820512010425g31300ac0x@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John D. Burger 2005-12-01 12:43:49 Re: Finding uniques across a big join
Previous Message Richard Huxton 2005-12-01 10:30:06 Re: postgres log file