On Saturday 16 October 2010 8:13:12 am Kynn Jones wrote: > I want to code a Perl function (part of a Perl library) for determining the > existence of a particular database (in a given host/port). > > One way would be to just attempt making a connection to it, trapping any > errors upon failure (with eval), or discarding the connection upon success. > > This approach has the added benefit of also checking the accessibility of > the database to the user running the code, but for this application this > added benefit is not necessary. Checking existence is all that matters. > > Is there an even faster way to check for a database's existence that does > not require establishing a connection? Given the restriction of host/port you probably need to connect as stated in other posts. For completeness though, it is possible to parse $DATA/global/pg_database for the existence of database in a particular cluster. Assuming you can map host/port to cluster then it is a possibility. > > (Maybe this question would be more suitable for the pgsql-performance > list?) > > TIA! > > ~kynn -- Adrian Klaver adrian.klaver@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
