Skip site navigation (1) Skip section navigation (2)

Re: Field list from table

From: rixder(at)o2(dot)pl
To: Jan Pips <jan_pips(at)op(dot)pl>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Field list from table
Date: 2004-02-29 20:48:18
Message-ID: 20040229204818.GA5888@SID (view raw or flat)
Thread:
Lists: pgsql-sql
On Thu, Feb 26, 2004 at 10:51:41AM +0100, Jan Pips wrote:
> How can I, using SELECT, get the full list of fields from a given table?
> 
> Pips
> 
> 
Hi !

Try it:

select * from table limit 0;

rixder

In response to

pgsql-sql by date

Next:From: Joe ConwayDate: 2004-02-29 23:32:40
Subject: Re: plpgsql function returning SETOF RECORD Question
Previous:From: Yasir MalikDate: 2004-02-29 20:22:01
Subject: Trouble with composite types

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group