Postgres Pro
Downloads
Home   >   mailing lists

Getting list of columns in a table - Mailing list pgsql-general

From Mike Blackwell
Subject Getting list of columns in a table
Date
Msg-id 1032376430.1820.39.camel@mike_b_linux.wallace.com
Whole thread Raw
Responses Re: Getting list of columns in a table
List pgsql-general
Tree view 
Sorry if this is a FAQ, but didn't see it in the web site FAQ or in the
docs I have.

I need a SQL statement which will return a list of the column names for
a (possibly empty) table.  FWIW, I'm using Perl and DBI.

TiA,
Mike
mblackwell@wallace.com

pgsql-general by date:

Previous
From: Neil Conway
Date:
Subject: Re: Automatic Indexes from Query Optimization?
Next
From: Jason Earl
Date:
Subject: Re: Getting list of columns in a table