From: Christoph Haller <ch@rodos.fzk.de>
To: Prime Ho <ho@optimasoft.com.tw>
Cc: pgsql-sql@postgresql.org
Subject: Re: how to get the source table & field name of a view field
Date: Thu, 07 Nov 2002 15:06:53 +0100
Message-ID: <3DCA737D.BB63C3C3@rodos.fzk.de> (raw)
> Could you tell me how to get view field's source table and field name?
> another word, how could I know the view field come from?
Within psql, use
\d <viewname>
to learn about the view's column names and types and the view
definition.
If you were thinking about querying system tables to get this
information,
start psql with the "-E" option to see how this \d <viewname> command
is implemented.
Regards, Christoph
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: ch@rodos.fzk.de, ho@optimasoft.com.tw
Subject: Re: how to get the source table & field name of a view field
In-Reply-To: <3DCA737D.BB63C3C3@rodos.fzk.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox