Thread: 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
createa 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
PSQLcommand. 

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
newPSQL 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
createa 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