Re: how could I get the source table name and field name from a view field

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(at)postgresql(dot)org
[mailto:pgsql-admin-owner(at)postgresql(dot)org]On Behalf Of Prime Ho
Sent: 07 November 2002 06:15
To: pgsql-admin(at)postgresql(dot)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