| 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 02:20:49 |
| Message-ID: | CAB8KJ=iFqsEqLAoy_JyY+SMsk1DTP-DBOpC48ko-A=5dvx1y8Q@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
014/1/2 peterlen <peteralen(at)earthlink(dot)net>:
> 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?
Those are the correct commands, but it sounds like you're using an older
psql version against a newer server. Which psql version (psql -V) are you using?
Regards
Ian Barwick
| From | Date | Subject | |
|---|---|---|---|
| Next Message | peterlen | 2014-01-02 02:35:55 | Re: How to list and describe tables in psql??? |
| Previous Message | Tom Lane | 2014-01-02 02:07:14 | Re: duplicate OID issue when using pg_upgrade to move from 8.4 to 9.2 |