To: <[EMAIL PROTECTED]>
Sent: Thursday, February 26, 2004 3:21 PM
Subject: [SQL] Field list from table
> How can I, using SELECT, get the full list of fields from a given table?
>
> Pips
>
>
>
> ---(end of broadcast)---
>
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
---(end of broadcast)---
TIP 5: Have you checked
How can I, using SELECT, get the full list of fields from a given table?
Pips
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
mess
"Jan Pips" <[EMAIL PROTECTED]> wrote:
> How can I, using SELECT, get the full list of fields from a given table?
portfolio=# select column_name, data_type from information_schema.columns where
table_catalog = 'portfolio' and table_schema = 'public' and table_name = 'stocktxns';
column_name |
