From: | Dave Page <dpage(at)vale-housing(dot)co(dot)uk> |
---|---|
To: | "'Anil Jangam'" <anilj(at)indts(dot)com> |
Cc: | pgsql-cygwin(at)postgresql(dot)org |
Subject: | Re: Can we refer to the column names as FK?? |
Date: | 2001-12-19 08:07:21 |
Message-ID: | FED2B709E3270E4B903EB0175A49BCB104738F@dogbert.vale-housing.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-cygwin |
> -----Original Message-----
> From: Anil Jangam [mailto:anilj(at)indts(dot)com]
> Sent: 19 December 2001 07:33
> To: 'Dave Page'
> Cc: pgsql-cygwin(at)postgresql(dot)org
> Subject: [CYGWIN] Can we refer to the column names as FK??
> Importance: High
>
>
> Hi,
>
> This is to check whether we can refer to column names as FK
> reference??
>
> So far when we define FK relation ship, we select the 'Local
> Column' and the 'Referenced Column'. Here essentially, the FK
> points to the contents/values entered under the given column
> name in the table (Correct me if I am wrong).
>
> Now if it is required to have column name itself as a
> reference AND NOT the
> *content* of the column, is it possible?? I am stuck with a
> similar requirement/situation.
It is not directly possible, though the system table pg_attribute contains
all the column definitions as data, and the view pg_tables contains all the
table info so you might be able to do something with them.
Regards, Dave.
From | Date | Subject | |
---|---|---|---|
Next Message | Anil Jangam | 2001-12-19 12:17:36 | Socket connection error... |
Previous Message | Dave Page | 2001-12-19 08:03:43 | Re: Bug report. |