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

From Raymond O'Donnell
Subject Re: How to list and describe tables in psql???
Date
Msg-id 52C547B8.7070502@iol.ie
Whole thread Raw
In response to How to list and describe tables in psql???  (peterlen <peteralen@earthlink.net>)
Responses Re: How to list and describe tables in psql???  (Abdul Sayeed <abdulsayeed24@gmail.com>)
List 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@iol.ie


pgsql-general by date:

Previous
From: "Janek Sendrowski"
Date:
Subject: Re: How to delete completely duplicate rows
Next
From: Abdul Sayeed
Date:
Subject: Re: How to list and describe tables in psql???