[SQL] Matching the MYSQL Describe table-name command

2005-04-24 Thread Alan Chandler
I am rather new to Postgres (running 7.4) but I am trying to port some PHP code that has been built to run with mysql. I have got stuck trying to find the equivalent of the Mysql DESCRIBE tablename; SQL statement that lists the columns and type identifiers of a table. I think I am going to do

Re: [SQL] Matching the MYSQL Describe table-name command

2005-04-24 Thread Alvaro Herrera
On Sun, Apr 24, 2005 at 07:02:16PM +0100, Alan Chandler wrote: I am rather new to Postgres (running 7.4) but I am trying to port some PHP code that has been built to run with mysql. I have got stuck trying to find the equivalent of the Mysql DESCRIBE tablename; SQL statement that lists the

Re: [SQL] Matching the MYSQL Describe table-name command

2005-04-24 Thread Stephen Frost
* Alan Chandler ([EMAIL PROTECTED]) wrote: I am rather new to Postgres (running 7.4) but I am trying to port some PHP code that has been built to run with mysql. I have got stuck trying to find the equivalent of the Mysql DESCRIBE tablename; SQL statement that lists the columns and type

Re: [SQL] Matching the MYSQL Describe table-name command

2005-04-24 Thread Andrew - Supernews
On 2005-04-24, Alan Chandler [EMAIL PROTECTED] wrote: I am rather new to Postgres (running 7.4) but I am trying to port some PHP code that has been built to run with mysql. I have got stuck trying to find the equivalent of the Mysql DESCRIBE tablename; SQL statement that lists the columns

Re: [SQL] Matching the MYSQL Describe table-name command

2005-04-24 Thread Tom Lane
Stephen Frost [EMAIL PROTECTED] writes: You might want to take a look at the schema called 'information_schema' and see if you can find what you want there. The only problem I have with that, currently anyway, is that it seems to only show things the current user owns as opposted to what the