Would pg_fieldname() and pg_fieldtype() also be an option? -----Original Message----- From: Josh Berkus [mailto:josh@xxxxxxxxxxxx] Sent: Thursday, May 02, 2002 6:49 PM To: ameen eetemadi; pgsql-php@xxxxxxxxxxxxxx Subject: Re: [PHP] type of a field Ameen, > I want to know the type of a field in a table > how can I khow it ? Way #1: 1. Log into to your database using the command line utility PSQL. 2. Type "\d <name of table>" Way #2: 1. Install phpPgAdmin database administration tool. 2. Examine the table using phpPgAdmin. -Josh ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org