> 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
