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