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

Hi,

On Thu, 2005-12-08 at 17:25 +0530, surabhi.ahuja wrote:
>  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';

SELECT 1 from pg_database WHERE datname='abc';

Regards,
--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/