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?
От
Carlos Santos
Тема
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?
Дата
Msg-id
20061219140105.74337.qmail@web57103.mail.re3.yahoo.com
Список
Дерево обсуждения
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? Carlos Santos <carloscompels@yahoo.com.br>
Re: Query a select that returns.... Achilleas Mantzios <achill@matrix.gatewaynet.com>
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
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
Compels Informática
Santa Rita do Sapucaí - MG
www.compels.net
Novidade no Yahoo! Mail: receba alertas de novas mensagens no seu celular. Registre seu aparelho agora!
В списке pgsql-sql по дате отправления
