[SQL] Field list from table

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

[SQL] Data type conversion

How to convert the interval type into integer, float or any "countable" data type at the time of table creation using select ... into? Pips ---(end of broadcast)--- TIP 8: explain analyze is your friend