Column names and datatypes

From: Glenn Sullivan <glenn(dot)sullivan(at)varianinc(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Column names and datatypes
Date: 2004-05-14 19:23:04
Message-ID: 40A51C98.2010304@varianinc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Carl E. McMillin 2004-05-14 19:43:43 Re: Column names and datatypes
Previous Message Vivek Khera 2004-05-14 18:36:53 Re: pg_xlog becomes extremely large during CREATE INDEX