Home > mailing lists

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

From	surabhi.ahuja
Subject	how to check if a database exists programatically
Date	December 8, 2005 10:55:40
Msg-id	967CFC4343BF2A4DAFACD026D33DC85118EC9F@jal.iiitb.ac.in Whole thread Raw
Responses	Re: how to check if a database exists programatically Re: how to check if a database exists programatically
List	pgsql-general

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';

From: Martijn van Oosterhout
Date: 08 December 2005, 10:43:28
Subject: Re: memory leak under heavy load?

From: "A. Kretschmer"
Date: 08 December 2005, 11:11:44
Subject: Re: how to check if a database exists programatically