Thread: 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.
Re: how could I get the source table name and field name from a view field
From
"Gareth Kirwan"
Date:
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