Re: How to list and describe tables in psql??? - Mailing list pgsql-general

From Ian Lawrence Barwick
Subject Re: How to list and describe tables in psql???
Date
Msg-id CAB8KJ=gGPmXjQ4Ms0qowp7hpOqrvQN7Jfx3O3ShKKqNngFG0qA@mail.gmail.com
Whole thread Raw
In response to Re: How to list and describe tables in psql???  (peterlen <peteralen@earthlink.net>)
List pgsql-general
2014/1/2 peterlen <peteralen@earthlink.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


pgsql-general by date:

Previous
From: peterlen
Date:
Subject: Re: How to list and describe tables in psql???
Next
From: sramay
Date:
Subject: pg_largeobject related issue with 9.2