Mikael Carneholm
2002-12-07 14:16:55 UTC
After upgrading to the 7.3 version and putting one of my databases
in a custom schema, I found out that the psql command
\d
(just \d, with no object specified)
reports 'No relations found', while
\d schemaname.tableFoo
displays the table information for tableFoo (and DbVisualizer sees
the table + other tables as well)
Strange, isn't it? I mean, shouldn't \d display all schemas &
their tables in the current database?
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ***@postgresql.org so that your
message can get through to the mailing list cleanly
in a custom schema, I found out that the psql command
\d
(just \d, with no object specified)
reports 'No relations found', while
\d schemaname.tableFoo
displays the table information for tableFoo (and DbVisualizer sees
the table + other tables as well)
Strange, isn't it? I mean, shouldn't \d display all schemas &
their tables in the current database?
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ***@postgresql.org so that your
message can get through to the mailing list cleanly