Postgres Pro
Downloads
Home   >   mailing lists

Re: Get name of columns in a table - Mailing list pgsql-sql

From Joel Burton
Subject Re: Get name of columns in a table
Date
Msg-id Pine.LNX.4.21.0107281030120.28378-100000@olympus.scw.org
Whole thread Raw
In response to Get name of columns in a table  (María Elena Hernández<mahelope@pereira.multi.net.co>)
List pgsql-sql
Tree view 
On Fri, 27 Jul 2001, [iso-8859-1] Mar�a Elena Hern�ndez wrote:

>  Is it possible to get thecoluns names of an a table in the database with a sql
> query??

"psql -E" will show the SQL commands that psql internally uses to display
tables, database, etc. Once in psql, use "\d table_name" to see fields in
a table and the SQL behind that.

--
Joel Burton   <jburton@scw.org>
Director of Information Systems, Support Center of Washington

pgsql-sql by date:

Previous
From: María Elena Hernández
Date:
Subject: Get name of columns in a table
Next
From: Roy Souther
Date:
Subject: Who do I make _ not a wildcard?