Who created the view ?
Are you talking about from a programming language interface, or from a psql
console?
\d view_name
will show you the fields and the view definition in the psql console.... is
that not what you want?
Sorry if I'm not helping - I may well not understand quite what it is you're
getting at.
You said that you've got a view field - well surely to get it you must
already know the view name ?
Regards
Gareth
-----Original Message-----
From: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org]On Behalf Of Prime Ho
Sent: 07 November 2002 06:15
To: pgsql-admin@postgresql.org
Subject: [ADMIN] how could I get the source table name and field name
from a view field
Hi, All
Could anyone tell me how could I get the source table & field name
from a view field?
Regards,
Ho.
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org