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: [EMAIL PROTECTED]
[mailto:pgsql-admin-owner@;postgresql.org]On Behalf Of Prime Ho
Sent: 07 November 2002 06:15
To: [EMAIL PROTECTED]
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



---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly

Reply via email to