Version 8.4.16 (no choice in version).
I log into my db as follows:
psql -d JRuser
The resulting prompt is:
JRuser=>
I do \d or \dt expecting to see a list of all the relations in schema 'translate'
No relations found.
But I can select from any of the tables in the schema without any issues. For example:
select * from translate.storage; --works fine
I have ensured that the access privileges are correct for JRuser by doing \dn+:
List of schemas
Name | Owner | Access privileges | Description
translate | JRuser | JRuser=UC/JRuser |
: postgres=UC/JRuser
Why can't I see the tables in the translate schema?
To show the name of the current schema, use the following simple command. >> SELECT current_schema(); This shows that the current schema is “public”.
PostgreSQL is a relational database management system ( RDBMS ). That means it is a system for managing data stored in relations. Relation is essentially a mathematical term for table.
\d
in psql only shows visible tables, i.e. in your search_path
.
Try and see:
SHOW search_path;
SET search_path= translate;
\d
The setting for your session has probably been changed somehow. There are multiple ways to do that:
Related later question on dba.SE:
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With