Postgres Pro
Downloads
Home   >   mailing lists

Re: how to check if a database exists programatically - Mailing list pgsql-general

From A. Kretschmer
Subject Re: how to check if a database exists programatically
Date
Msg-id 20051208121141.GE11861@webserv.wug-glas.de
Whole thread Raw
In response to how to check if a database exists programatically  ("surabhi.ahuja" <surabhi.ahuja@iiitb.ac.in>)
List pgsql-general
Tree view 
am  08.12.2005, um 17:25:10 +0530 mailte surabhi.ahuja folgendes:
>  i have to write a shell script in which i have to check if the database "abc" exists or not
>
> how should i do it ? some select query
>
> select * from ??? where database_name = 'abc';

You can parse the output from 'psql -l'.


HTH, Andreas
--
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47212,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
 ===    Schollglas Unternehmensgruppe    ===

pgsql-general by date:

Previous
From: "surabhi.ahuja"
Date:
Subject: how to check if a database exists programatically
Next
From: Devrim GUNDUZ
Date:
Subject: Re: how to check if a database exists programatically