Discussion:
Quick Question Please
(too old to reply)
Terry Hampton
2003-12-18 20:30:41 UTC
Permalink
All,

Seem to be having a brain lock.

What is the method or syntax to return
a list of column names for a given table name ?

many thanks for your quick help,
Terry
--
Terry L. Hampton
Program Manager
LimaCorp, LLC. www.limacorp.com
513.587.1874



---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
Sam Barnett-Cormack
2003-12-18 20:41:29 UTC
Permalink
In psql, do

\d table_name

It will tell you about all columns, indexes, and constraints.
Post by Terry Hampton
All,
Seem to be having a brain lock.
What is the method or syntax to return
a list of column names for a given table name ?
many thanks for your quick help,
Terry
--
Sam Barnett-Cormack
Software Developer | Student of Physics & Maths
UK Mirror Service (http://www.mirror.ac.uk) | Lancaster University

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html
Sergio Pili
2003-12-18 20:33:58 UTC
Permalink
In psql:

\d [table name]

Regards,

Sergio Pili
-----Mensaje original-----
Enviado el: Jueves 18 de Diciembre de 2003 17:31
Asunto: [ADMIN] Quick Question Please
All,
Seem to be having a brain lock.
What is the method or syntax to return
a list of column names for a given table name ?
many thanks for your quick help,
Terry
--
Terry L. Hampton
Program Manager
LimaCorp, LLC. www.limacorp.com
513.587.1874
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
Bruno LEVEQUE
2003-12-18 20:42:40 UTC
Permalink
A solution :

in psql :

\d YourTable
Post by Terry Hampton
All,
Seem to be having a brain lock.
What is the method or syntax to return
a list of column names for a given table name ?
many thanks for your quick help,
Terry
--
Bruno LEVEQUE
System Engineer
SARL NET6D
***@net6d.com
http://www.net6d.com



---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
charlie derr
2003-12-18 20:44:36 UTC
Permalink
From a psql prompt:


\d <tablename>

good luck,
~c
Post by Terry Hampton
All,
Seem to be having a brain lock.
What is the method or syntax to return
a list of column names for a given table name ?
many thanks for your quick help,
Terry
--
if i top posted, i probably did it on purpose, and yes i know my lines
might trail out the right end of your mail viewer/client (but only if
you have an inadequate one)


---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
Loading...