Posted by Andy Hassall on 08/23/05 23:52

On 22 Aug 2005 16:17:11 -0700, bissatch@yahoo.co.uk wrote:

>If I want to determine what data types a table has, how would I do this
>using PHP?
>
>I tried looking into SHOW TABLES but would I be correct in saying that
>just displays a list of tables? I want some way of analizing a single
>table and outputing the column data types. Btw, I am using a PostgreSQL
>database.

http://www.postgresql.org/docs/8.0/interactive/information-schema.html
http://groups.google.co.uk/groups/dir?q=comp.databases.postgresql&hl=en

--
Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool

• Next in forum: Re: PHP to echo a line in html source...
• Prev in forum: Re: GET varaibles with irregular characters
• Thread view: Re: Displaying column data types in a table?

[Reply to this message]