From: Carlos Santos <carloscompels@yahoo.com.br>
To: Lista PostgreSQL SQL <pgsql-sql@postgresql.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: Tue, 19 Dec 2006 06:01:05 -0800 (PST)
Message-ID: <20061219140105.74337.qmail@web57103.mail.re3.yahoo.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: carloscompels@yahoo.com.br
Subject: Re: 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?
In-Reply-To: <20061219140105.74337.qmail@web57103.mail.re3.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox