>
> if I want to write a function for getting the view.field's source
> table.field
> how could I achieve it?
>
This sounds like a real challange.
Throughout the years I've had to learn it's always a pain to
retrieve system catalog information - no matter which
DBMS is in use.
On the other hand, yo
On Thu, Nov 07, 2002 at 05:12:20PM +0800, Prime Ho wrote:
> Hi,
>
> 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?
>
\d view_name should give you the view definition in pqsl.
--
Ken Kennedy | http://www.ke
On Thu, 7 Nov 2002, Prime Ho wrote:
> Hi,
>
> 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?
SELECT definition from pg_views where viewname='';
>
> Regards,
> Ho
>
>
>
> ---(end of broadcas
> 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
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
informa
Hi,
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?
Regards,
Ho
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
