Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id 5D6992E004C for ; Tue, 15 Apr 2008 08:15:33 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 99657-07 for ; Tue, 15 Apr 2008 08:15:18 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from megafon.hr (megafon.hr [213.202.104.5]) by developer.postgresql.org (Postfix) with ESMTP id 6C5D32E0051 for ; Tue, 15 Apr 2008 08:15:24 -0300 (ADT) Received: from localhost (localhost.localdomain [127.0.0.1]) by megafon.hr (Postfix) with ESMTP id 7C0BE250058 for ; Tue, 15 Apr 2008 13:15:21 +0200 (CEST) X-Virus-Scanned: ClamAV at megafon.hr Received: from megafon.hr ([127.0.0.1]) by localhost (localhost.localdomain [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id nIp14Me-K3NS for ; Tue, 15 Apr 2008 13:15:10 +0200 (CEST) Received: from [192.168.1.94] (unknown [213.147.122.162]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) (Authenticated sender: mike) by megafon.hr (Postfix) with ESMTP id C41A225004D for ; Tue, 15 Apr 2008 13:15:10 +0200 (CEST) Message-ID: <48048E3E.2090807@megafon.hr> Date: Tue, 15 Apr 2008 13:15:10 +0200 From: Mario Splivalo User-Agent: Thunderbird 2.0.0.12 (X11/20080227) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: psql shell return codes - checking if database exists Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200804/140 X-Sequence-Number: 28904 I need to check, from a bash script, if certain database exists in a postgres cluster. When I issue: psql -U someuser somedatabase psql returns error code 2 regardless of 'no user' or 'no database' condition. How could I distinguish from the two? Mario