| From: | Joel Burton <jburton(at)scw(dot)org> |
|---|---|
| To: | María Elena Hernández <mahelope(at)pereira(dot)multi(dot)net(dot)co> |
| Cc: | pgsql-sql(at)postgresql(dot)org, pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: Get name of columns in a table |
| Date: | 2001-07-28 14:31:32 |
| Message-ID: | Pine.LNX.4.21.0107281030120.28378-100000@olympus.scw.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice pgsql-sql |
On Fri, 27 Jul 2001, [iso-8859-1] Mara Elena Hernndez 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(at)scw(dot)org>
Director of Information Systems, Support Center of Washington
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bryan Buchanan | 2001-07-29 02:16:58 | triggers with parameters |
| Previous Message | Mithun Bhattacharya | 2001-07-28 14:29:32 | Re: Postgresql & Redhat 6.2 = memory leak? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Roy Souther | 2001-07-28 18:12:51 | Who do I make _ not a wildcard? |
| Previous Message | Stephan Szabo | 2001-07-28 03:48:44 | Re: Why does this plpgslq always return 1? |