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/
