Received: from Net-One.de ([195.50.164.1]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f9KJ4FP08805 for ; Sat, 20 Oct 2001 15:04:15 -0400 (EDT) (envelope-from knut.suebert@web.de) Received: from cascal.vtb (root@localhost [127.0.0.1]) by localhost (8.11.3/8.11.3/Debian 8.11.2-1) with ESMTP id f9KJ8qX31599 for ; Sat, 20 Oct 2001 21:08:53 +0200 Received: from ksueber by cascal.vtb with local (Exim 3.32 #1 (Debian)) id 15v0Ol-0002De-00 for ; Sat, 20 Oct 2001 19:59:03 +0200 Date: Sat, 20 Oct 2001 19:59:03 +0200 To: pgsql-php@postgresql.org Subject: how to get the field types of a(n empty) table? Message-ID: <20011020195903.A8147@cascal.vtb> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit User-Agent: Mutt/1.3.18i X-No-Archive: yes From: knut.suebert@web.de X-Archive-Number: 200110/79 X-Sequence-Number: 632 Hello, is there a possibility to get the field types of an empty table? I made a class for editing tables in a html form. The data is inserted or updated by something like "update $table set $row='$DATA'::$ftype[$row] where oid=$oid" The type of the fields is gotten by a "select $rows from $table limit 1" -- but this is only possible, if there is at least one row inside a table (for an "insert", "update" is no problem, of course). It should be possible by reading something out of the postgres' system tables, but I didn't found it. Thank in advance, Knut Sübert