X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (mx1.hub.org [200.46.208.251])
	by postgresql.org (Postfix) with ESMTP id 618B69FA19B
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 17 May 2006 04:41:39 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024)
	with ESMTP id 45866-06
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 17 May 2006 04:41:34 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from matrix.gatewaynet.com (host2.dynacom.ondsl.gr [62.103.35.210])
	by postgresql.org (Postfix) with ESMTP id 188AB9F9430
	for <pgsql-sql@postgresql.org>; Wed, 17 May 2006 04:41:31 -0300 (ADT)
Received: from matrix.gatewaynet.com (localhost.localdomain [127.0.0.1])
	by matrix.gatewaynet.com (8.12.8/8.12.8) with ESMTP id k4H7pjee023965;
	Wed, 17 May 2006 10:51:45 +0300
Received: from localhost (achill@localhost)
	by matrix.gatewaynet.com (8.12.8/8.12.8/Submit) with ESMTP id
	k4H7pjbj023961; Wed, 17 May 2006 10:51:45 +0300
Date: Wed, 17 May 2006 10:51:45 +0300 (EEST)
From: Achilleus Mantzios <achill@matrix.gatewaynet.com>
To: Kis =?iso-8859-2?q?J=E1nos_Tam=E1s?= <kjt@takarnet.hu>
cc: PostgreSQL SQL List <pgsql-sql@postgresql.org>
Subject: Re: Database OID
In-Reply-To: <200605170810.42681.kjt@takarnet.hu>
Message-ID: <Pine.LNX.4.44.0605171051150.23959-100000@matrix.gatewaynet.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=ISO-8859-7
Content-Transfer-Encoding: 8BIT
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200605/115
X-Sequence-Number: 25146

O Kis János Tamás Ýăńářĺ óôéň May 17, 2006 :

> Hi,
> 
> How can I find the database OID from simple SQL command?

SELECT oid,* from pg_database <where .....>;

> 
> Thanks,
> kjt
> 
> 
> McAfee SCM 4.1 által ellenőrizve!
> 
> ---------------------------(end of broadcast)---------------------------TIP 6: explain analyze is your friend
> 

-- 
-Achilleus