Re: sql to get the column names of a table

From: Devrim GUNDUZ <devrim(at)gunduz(dot)org>
To: Alexander Antonakakis <motoris(at)sdf(dot)lonestar(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: sql to get the column names of a table
Date: 2004-01-20 11:08:21
Message-ID: Pine.LNX.4.44.0401201307590.25286-100000@emo.org.tr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

-----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(at)gunduz(dot)org devrim(dot)gunduz(at)linux(dot)org(dot)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-----

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John Sidney-Woollett 2004-01-20 11:34:35 Re: sql to get the column names of a table
Previous Message Alexander Antonakakis 2004-01-20 10:23:01 sql to get the column names of a table