Frank Church wrote:
Quoting Tom Lane <tgl@xxxxxxxxxxxxx>:
Can this info be obtained by querying the system tables,
especially in the case of views? I am using 'scripting' languages and using C
will be quite awkward.
I have got to find if libpq's output is exposed in PHP or Ruby.
Frank Church <pgsql@xxxxxxxxxxxxxx> writes:
Is there way to determine the table a query or a view's columns come from?
Yeah, there's some support for that in the protocol. libpq exposes it
as PQftable() and PQftablecol().
Do you need this?
test=# \d x
View "public.x"
Column | Type | Modifiers
--------+-----------------------+-----------
name | character varying(50) |
View definition:
SELECT questions.name
FROM questions;
If you need to see what query "\d x" is running, start psql with -E and
it will show it.
--
Postgresql & php tutorials
http://www.designmagick.com/
