tablemeta-data

From: Erik Price <eprice(at)ptc(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: tablemeta-data
Date: 2003-05-22 16:58:21
Message-ID: 3ECD01AD.6000904@ptc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message scott.marlowe 2003-05-22 17:05:20 Re: SELECT DISTINCT ON bug?
Previous Message scott.marlowe 2003-05-22 16:56:46 Re: PRIMARY KEYS