Re: SQL statement : list table details - Mailing list pgsql-general

From Neil Conway
Subject Re: SQL statement : list table details
Date
Msg-id 1014944328.374.17.camel@jiro
Whole thread Raw
In response to Re: SQL statement : list table details  (Samik Raychauhduri <samik@cae.wisc.edu>)
List pgsql-general
On Thu, 2002-02-28 at 19:59, Samik Raychauhduri wrote:
> Hi,
> Thanks for this query BTW, I was looking for a query like this :)
> Let's see if anybody comes up with any solution to the data types.

Do this:

$ psql -E
nconway=> \d my_table

This will display the queries that psql uses to determine the data types
of a table. The same holds true for all the other psql 'slash commands'.

Cheers,

Neil

--
Neil Conway <neilconway@rogers.com>
PGP Key ID: DB3C29FC


pgsql-general by date:

Previous
From: Samik Raychauhduri
Date:
Subject: Re: SQL statement : list table details
Next
From: Stephan Szabo
Date:
Subject: Re: SQL statement : list table details