Re: tablemeta-data - Mailing list pgsql-general

From Erik Price
Subject Re: tablemeta-data
Date
Msg-id 3ECE6C32.2050204@ptc.com
Whole thread Raw
In response to Re: tablemeta-data  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-general

Bruno Wolff III wrote:
> On Thu, May 22, 2003 at 12:58:21 -0400,
>   Erik Price <eprice@ptc.com> wrote:
>
>>Hi,
>>
>>Is there a way to execute a query that returns meta-data about the
>>tables?  Specifically I am interested in a psql command to display
>>information about a table's column names and types.
>
>
> \d table_name
>
> Use \? to get a list of \ commands.

Thanks everyone for these commands.  I thought I had read through the
options in "\?" but guess I didn't look too closely.  This is exactly
what I was looking for.


Regards,

Erik


pgsql-general by date:

Previous
From: Manfred Koizar
Date:
Subject: Re: [ADMIN] Q: Structured index - which one runs faster?
Next
From: Andrew Sullivan
Date:
Subject: Re: UFS Logging on Solaris 8