Re: How can i get the column names?

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: freenet <leouhlig(at)freenet(dot)de>
Cc: psql_list <pgsql-general(at)postgresql(dot)org>
Subject: Re: How can i get the column names?
Date: 2002-10-28 13:15:47
Message-ID: 20021028131547.GH23020@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Oct 28, 2002 at 01:57:04PM +0100, freenet wrote:
> Hi,
> For an aplication i need to get only the column names!
> I'm trying to select the column names from a table, but without success.
> Can anybody instruct me how can i do it?

$ psql -E db
db> \d

That should give you the queries you want.
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> There are 10 kinds of people in the world, those that can do binary
> arithmetic and those that can't.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2002-10-28 13:19:40 Re: Turning the PLANNER off
Previous Message freenet 2002-10-28 12:57:04 How can i get the column names?