Re: Get a list of columns for a table - Mailing list pgsql-novice

From Josh Berkus
Subject Re: Get a list of columns for a table
Date
Msg-id 200509071641.51015.josh@agliodbs.com
Whole thread Raw
In response to Get a list of columns for a table  ("Kevin Crenshaw" <kcrenshaw@viscient.com>)
List pgsql-novice
Kevin,

> How do I retrieve a list of columns for a table from an outside
> application? I don't want to retrieve any rows from the table just the
> column related data like what is retrieved using '\d [table name]' in
> psql.  Can this be done using a simple Select statement?

Yes.  Look up INFORMATION_SCHEMA in the PostgreSQL Docs.

--
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco

pgsql-novice by date:

Previous
From:
Date:
Subject: Weird SQL Problem
Next
From: Josh Berkus
Date:
Subject: Re: Weird SQL Problem