X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id 1DD7FD1E94E
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Sun, 29 Feb 2004 20:48:21 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 83050-03
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Sun, 29 Feb 2004 16:48:20 -0400 (AST)
Received: from kogut3.o2.pl (kogut3.go2.pl [212.126.20.24])
	by svr1.postgresql.org (Postfix) with ESMTP id 81792D1E949
	for <pgsql-sql@postgresql.org>; Sun, 29 Feb 2004 16:48:16 -0400 (AST)
Received: from localhost (rekin7.go2.pl [212.126.20.19])
	(using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits))
	(No client certificate requested)
	by kogut3.o2.pl (Postfix) with ESMTP id 075EE78120;
	Sun, 29 Feb 2004 21:48:17 +0100 (CET)
Date: Sun, 29 Feb 2004 21:48:18 +0100
From: rixder@o2.pl
To: Jan Pips <jan_pips@op.pl>
Cc: pgsql-sql@postgresql.org
Subject: Re: Field list from table
Message-ID: <20040229204818.GA5888@SID>
Mail-Followup-To: rixder@o2.pl, Jan Pips <jan_pips@op.pl>,
	pgsql-sql@postgresql.org
References: <c1kfka$2l33$1@mamut.aster.pl>
Mime-Version: 1.0
Content-Type: text/plain; charset=iso-8859-2
Content-Disposition: inline
In-Reply-To: <c1kfka$2l33$1@mamut.aster.pl>
User-Agent: Mutt/1.5.5.1+cvs20040105i
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200402/402
X-Sequence-Number: 17092

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