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