Postgres Pro
Downloads
Home   >   mailing lists

Column names and datatypes - Mailing list pgsql-general

From Glenn Sullivan
Subject Column names and datatypes
Date
Msg-id 40A51C98.2010304@varianinc.com
Whole thread Raw
Responses Re: Column names and datatypes  ("Carl E. McMillin" <carlymac@earthlink.net>)
Re: Column names and datatypes  (Mike Mascari <mascarm@mascari.com>)
List pgsql-general
Tree view 
I need to acquire the list of all column names and datatypes
from a table through the JDBC interface using an sql command.
What I want is available in "psql" with the "\d tablename"
command, but I cannot figure out how to get these via an sql
command.  Can anyone help?

Thanks,

Glenn

pgsql-general by date:

Previous
From: Vivek Khera
Date:
Subject: Re: pg_xlog becomes extremely large during CREATE INDEX
Next
From: "Carl E. McMillin"
Date:
Subject: Re: Column names and datatypes