> 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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
