tablemeta-data - Mailing list pgsql-general

From Erik Price
Subject tablemeta-data
Date
Msg-id 3ECD01AD.6000904@ptc.com
Whole thread Raw
Responses Re: tablemeta-data  (Bruno Wolff III <bruno@wolff.to>)
Re: tablemeta-data  ("Jim C. Nasby" <jim@nasby.net>)
List pgsql-general
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.

I have moved from MySQL to PostgreSQL to expand my horizons but the SHOW
DATABASES and DESCRIBE some_table commands are the ones I find myself
missing the most.  Perhaps there's some SQL that approximates it.

Thanks,

Erik


pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Is this a bug? : select '26/10/2003'::date + interval
Next
From: "scott.marlowe"
Date:
Subject: Re: PRIMARY KEYS