| From: | Ian Lawrence Barwick <barwick(at)gmail(dot)com> |
|---|---|
| To: | peterlen <peteralen(at)earthlink(dot)net> |
| Cc: | PG-General Mailing List <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: How to list and describe tables in psql??? |
| Date: | 2014-01-02 03:02:26 |
| Message-ID: | CAB8KJ=gGPmXjQ4Ms0qowp7hpOqrvQN7Jfx3O3ShKKqNngFG0qA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
2014/1/2 peterlen <peteralen(at)earthlink(dot)net>:
> Thanks for the responses. I found that I was using an older version of psql
> (one that got installed when I installed Cygwin on my windows box. I
> changed it so now the \d+
> gives me the description but \d and \dt still gives me "No relations
> found" so I must be using those incorrectly.
Possibly there's an issue with your search path?
Check if "\dn" lists schemas not listed by "SHOW search_path", if so
you can either explicitly include the schema name (\dt some_schema.*) or
adjust your search path.
See also:
http://www.postgresql.org/docs/current/interactive/ddl-schemas.html#DDL-SCHEMAS-PATH
Regards
Ian Barwick
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew McIntyre | 2014-01-02 03:35:36 | question on parallelism |
| Previous Message | peterlen | 2014-01-02 02:35:55 | Re: How to list and describe tables in psql??? |