Skip site navigation (1) Skip section navigation (2)

Get a list of columns for a table

From: "Kevin Crenshaw" <kcrenshaw(at)viscient(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Get a list of columns for a table
Date: 2005-09-07 22:19:35
Message-ID: 20050907222005.400BED82FA@svr1.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-novice
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?
 
Thanks for your help!
 
Kevin

Responses

pgsql-novice by date

Next:From: Kevin CrenshawDate: 2005-09-07 22:24:19
Subject: MVCC handling of updates
Previous:From: Renaldo HyltonDate: 2005-09-07 19:13:27
Subject: Transfer to MSSQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group