| From: | Raymond O'Donnell <rod(at)iol(dot)ie> |
|---|---|
| To: | peterlen <peteralen(at)earthlink(dot)net>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: How to list and describe tables in psql??? |
| Date: | 2014-01-02 11:04:24 |
| Message-ID: | 52C547B8.7070502@iol.ie |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 02/01/2014 01:53, peterlen wrote:
> I am using PostgreSQL 9.1 and have boon looking for psql commands to list all
> tables in the current database as well as how to "describe" a given table.
> I have come across some info on the web (older mostly) that lists commands
> like \d, \dt, or \d+ <tablename> but I get results like "no relations found"
> or "column reltriggers does not exist". Not sure what is going on.
>
> Can someone enlighten me on the right commands to use?
Possibly a silly question, but are you connected to the correct
database? If you don't specify a database on the psql command line, then
psql connects to a database with the same name as the username you use
to connect, if such a database exists.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
rod(at)iol(dot)ie
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Abdul Sayeed | 2014-01-02 12:32:27 | Re: How to list and describe tables in psql??? |
| Previous Message | Janek Sendrowski | 2014-01-02 10:33:39 | Re: How to delete completely duplicate rows |