Postgres Pro
Downloads
Home   >   mailing lists

Re: sql to get the column names of a table - Mailing list pgsql-general

From Devrim GUNDUZ
Subject Re: sql to get the column names of a table
Date
Msg-id Pine.LNX.4.44.0401201307590.25286-100000@emo.org.tr
Whole thread Raw
In response to sql to get the column names of a table  (Alexander Antonakakis <motoris@sdf.lonestar.org>)
Responses Re: sql to get the column names of a table  ("John Sidney-Woollett" <johnsw@wardbrook.com>)
List pgsql-general
Tree view 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


Hi,

On Tue, 20 Jan 2004, Alexander Antonakakis wrote:

> How can I get the column names of a table with sql ?

 SELECT tablename FROM pg_tables WHERE tablename NOT LIKE 'pg_%';

will work, I think.

Regards,
- --
Devrim GUNDUZ
devrim@gunduz.org                devrim.gunduz@linux.org.tr
            http://www.TDMSoft.com
            http://www.gunduz.org
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQFADQwotl86P3SPfQ4RAo7QAKDbpCxKPhgsoMuvqYPgWIv/4Yp71ACePcd7
brSaT7Ur5cUZ9bz54bii9Qg=
=B1/n
-----END PGP SIGNATURE-----

pgsql-general by date:

Previous
From: Alexander Antonakakis
Date:
Subject: sql to get the column names of a table
Next
From: Stephan Szabo
Date:
Subject: Re: Foreign key constraint accepted even when not same