Looking at a table

"Paul Ottar Tornes" <critical@tiscali.no> writes:

I can do psql -l to look at all the databases and owners. But is
there a way to look at the contents of the table "nyheter" in the
database "maloy" ?

\d nyheter when connected to the "maloy" database, perhaps? If you'd
like to see the SQL that psql uses to produce that info, start psql
with the "-E" flag.

Cheers,

Neil

--
Neil Conway <neilc@samurai.com> || PGP Key ID: DB3C29FC

On Wed, 30 Oct 2002, Paul Ottar Tornes wrote:

I have a database named "maloy" and within that I have a table named "nyheter"
I can do psql -l to look at all the databases and owners. But is there
a way to look at the contents of the table "nyheter" in the database
"maloy" ?

psql nyheter -c -- 'select * from maloy'

should do it.