View Single Post

   
  #2 (permalink)  
Old 04-17-2008, 04:10 PM
Milen A. Radev
 
Posts: n/a
Default Re: psql shell return codes - checking if database exists

Mario Splivalo написа:
> 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?


A workaround: add "--list" option to the command line and grep for the
database you need.


--
Milen A. Radev


--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Reply With Quote