Bug or limitation?
I'm using PostgreSQL 7.3.2 (from RPM on this site) on RH Linux 7. I'm investigating using "schemas", but after I create a schema, I try to rename an existing table into the new schema with:
ALTER TABLE name RENAME TO schema.name;
This fails in parsing. Is this a bug or a (current) limitation of schemas?
Also, the only way I could find to list my schemas is:
SELECT * FROM pg_namespace;
And I had to go to the mailing lists to find that out; is it in the docs? For version 7.4 I'd suggest "\dn" as a new PSQL command.
Sincerely, Dean
On Wed, May 07, 2003 at 23:31:24 -0700,
"Dean Gibson (DB Administrator)" <dba-sql@ultimeth.net> wrote:
And I had to go to the mailing lists to find that out; is it in the docs? For version 7.4 I'd suggest "\dn" as a new PSQL command.
That command is already in 7.4.
"Dean Gibson (DB Administrator)" <dba-sql@ultimeth.net> writes:
I'm using PostgreSQL 7.3.2 (from RPM on this site) on RH Linux 7. I'm investigating using "schemas", but after I create a schema, I try to rename an existing table into the new schema with:
ALTER TABLE name RENAME TO schema.name;
There's no provision for moving things across schemas at the moment.
regards, tom lane