Query a select that returns all the fields of an specific value of primary key without knownig the name of the single column's primary key?

From: Carlos Santos <carloscompels(at)yahoo(dot)com(dot)br>
To: Lista PostgreSQL SQL <pgsql-sql(at)postgresql(dot)org>
Subject: Query a select that returns all the fields of an specific value of primary key without knownig the name of the single column's primary key?
Date: 2006-12-19 14:01:05
Message-ID: 20061219140105.74337.qmail@web57103.mail.re3.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi!
I need to query a select that returns all the fields of an specific primary key, but I don't have the single column's name that is constrained as primary key.
How can I do that?
Something like:
SELECT * FROM myTable WHERE myTable.pkey = 'foo';

Thanks

Carlos Henrique Iazzetti Santos
Compels Informática
Santa Rita do Sapucaí - MG
www.compels.net


_______________________________________________________
O Yahoo! está de cara nova. Venha conferir!
http://br.yahoo.com

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Markus Schaber 2006-12-19 14:23:00 Re: Autovaccum
Previous Message Ragnar 2006-12-18 21:56:28 Re: SELECT with WHERE clause by column number