From: Papp Gyozo <pgerzson@freestart.hu>
To: pgsql-php@postgresql.org
To: knut.suebert@web.de
Subject: Re: how to get the field types of a(n empty) table?
Date: Mon, 22 Oct 2001 17:59:03 +0200
Message-ID: <007f01c15b12$7ea3fda0$01fdfea9@jaguar> (raw)
References: <20011020195903.A8147@cascal.vtb>
If you runs psql with -E option, then psql reveals the SQL equivalent of its
magical metacommands starting with a backslash ie.: \dv \d and so on.
Use those queries to get the columns' types!
<manual src="app-psql.html">
-E, --echo-hidden
Echoes the actual queries generated by \d and other backslash commands. You
can use this if you wish to include similar functionality into your own
programs. This is equivalent to setting the variable ECHO_HIDDEN from within
psql.
</manual>
----- Original Message -----
From: <knut.suebert@web.de>
To: <pgsql-php@postgresql.org>
Sent: Saturday, October 20, 2001 7:59 PM
Subject: [PHP] how to get the field types of a(n empty) table?
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
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-php@postgresql.org
Cc: pgerzson@freestart.hu, knut.suebert@web.de
Subject: Re: how to get the field types of a(n empty) table?
In-Reply-To: <007f01c15b12$7ea3fda0$01fdfea9@jaguar>
References: <20011020195903.A8147@cascal.vtb> <007f01c15b12$7ea3fda0$01fdfea9@jaguar>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox