FAQ
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

Search Discussions

  • Bruno Wolff III at May 8, 2003 at 1:50 pm

    On Wed, May 07, 2003 at 23:31:24 -0700, "Dean Gibson (DB Administrator)" 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.
  • Tom Lane at May 8, 2003 at 2:15 pm

    "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

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-general @
categoriespostgresql
postedMay 8, '03 at 6:31a
activeMay 8, '03 at 2:15p
posts3
users3
websitepostgresql.org
irc#postgresql

People

Translate

site design / logo © 2022 Grokbase