Re: PQftable insufficient for primary key determination - Mailing list pgsql-general

On Fri, Jul 16, 2004 at 03:38:52 +0200,
  Michal Maru?ka <mmc@maruska.dyndns.org> wrote:
>
>
> Imagine i have a table A with primary key "p" and another attribute called "data":
>
> SELECT * from A, A, B;
>
> here, i will have 2 columns "data", PQftable tells me that they are from A, but
> which of the 2 columns "p" is the primary key of the tuple (of the table A)?
>
>
> Is it possible to get distinguish the 2 instances of the table A?

You can use aliases to distinguish between two references to the same
table in a query. Your question doesn't make a lot of sense though, since
you haven't said which of the two copies of A you are interested in.