Received: from localhost (maia-4.hub.org [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 457C39FA111
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Tue, 19 Dec 2006 10:01:15 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024)
	with ESMTP id 74559-07 for <pgsql-sql-postgresql.org@postgresql.org>;
	Tue, 19 Dec 2006 10:01:07 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.4
Received: from web57103.mail.re3.yahoo.com (web57103.mail.re3.yahoo.com
	[216.252.111.116])
	by postgresql.org (Postfix) with SMTP id 440EB9F946C
	for <pgsql-sql@postgresql.org>; Tue, 19 Dec 2006 10:01:07 -0400 (AST)
Received: (qmail 74339 invoked by uid 60001); 19 Dec 2006 14:01:05 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com.br;
	h=Message-ID:Received:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type;
	b=inIqW7CB9p3Y189sg8yCIgs4CNfzB+hGD9mfxmU/aOJ20zK+IV4fUbU4wJAiQs+fOJYDVQ6uT5oWRogbJDjJHQUnOLWuGsxvQTi/dQNfuY1JrKehXudvkBKWJ4s/0mJ9EQEb326tMGZqun6Xd0jHK2v9w+l07IZ172DMvfhnXkE=
	;
Message-ID: <20061219140105.74337.qmail@web57103.mail.re3.yahoo.com>
Received: from [201.58.182.50] by web57103.mail.re3.yahoo.com via HTTP;
	Tue, 19 Dec 2006 06:01:05 PST
Date: Tue, 19 Dec 2006 06:01:05 -0800 (PST)
From: Carlos Santos <carloscompels@yahoo.com.br>
Reply-To: Carlos Santos <carlos@compels.net>
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?
To: Lista PostgreSQL SQL <pgsql-sql@postgresql.org>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-43705013-1166536865=:74134"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200612/133
X-Sequence-Number: 27089

--0-43705013-1166536865=:74134
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

Hi!=0AI need to query a select that returns all the fields of an specific p=
rimary key, but I don't have the  single column's name that is constrained =
as primary key.=0AHow can I do that?=0ASomething like:=0ASELECT * FROM myTa=
ble WHERE myTable.pkey =3D 'foo';=0A=0AThanks=0A =0ACarlos Henrique Iazzett=
i Santos =0ACompels Inform=E1tica =0A Santa Rita do Sapuca=ED - MG=0Awww.co=
mpels.net=0A=0A=0A=0A=0A=0A=09=09=0A_______________________________________=
________________ =0AO Yahoo! est=E1 de cara nova. Venha conferir! =0Ahttp:/=
/br.yahoo.com
--0-43705013-1166536865=:74134
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

<html><head><style type=3D"text/css"><!-- DIV {margin:0px;} --></style></he=
ad><body><div style=3D"font-family:times new roman, new york, times, serif;=
font-size:10pt">Hi!<br>I need to query a select that returns all the fields=
 of an specific primary key, but I don't have the&nbsp; single column's nam=
e that is constrained as primary key.<br>How can I do that?<br>Something li=
ke:<br>SELECT * FROM myTable WHERE myTable.pkey =3D 'foo';<br><br>Thanks<br=
><div>&nbsp;</div><span style=3D"color: rgb(0, 96, 191);">Carlos Henrique I=
azzetti Santos </span><br style=3D"color: rgb(0, 96, 191);"><span style=3D"=
color: rgb(0, 96, 191);">Compels Inform=E1tica </span><br style=3D"color: r=
gb(0, 96, 191);"><span style=3D"color: rgb(0, 96, 191);"> Santa Rita do Sap=
uca=ED - MG</span><br><a style=3D"color: rgb(0, 96, 191);" href=3D"http://w=
ww.compels.net">www.compels.net</a><br><div><br></div></div><br>=0A=09=09<h=
r size=3D1> =0ANovidade no Yahoo! Mail: receba alertas de novas mensagens n=
o seu celular. <a href=3D"http://us.rd.yahoo.com/mail/br/tagline/mobile_ale=
rts/*http://br.mobile.yahoo.com/mailalertas/">Registre seu aparelho agora!<=
/a></body></html>
--0-43705013-1166536865=:74134--