Rod Taylor <[EMAIL PROTECTED]> writes:
> Appears psql needs to know how to differentiate between it's own temp
> tables and those of another connection.
More generally, psql is as yet clueless about schemas.
regression=# create schema foo;
CREATE
regression=# create schema bar;
CREATE
regression=# create table foo.tab1 (f1 int);
CREATE
regression=# create table bar.tab1 (f2 int);
CREATE
regression=# \d tab1
Table "tab1"
Column | Type | Modifiers
--------+---------+-----------
f1 | integer |
f2 | integer |
This is ... um ... wrong. I am not real sure what the right behavior
is, however. Should \d accept patterns like schema.table (and how
should its wildcard pattern matching fit with that?) If you don't
specify a schema, should it only show tables visible in your search
path?
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
