Fastest way to check database's existence

From: Kynn Jones <kynnjo(at)gmail(dot)com>
To: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Fastest way to check database's existence
Date: 2010-10-16 15:13:12
Message-ID: AANLkTin-hJvD6Li6mg7P80+vxAx5Efg+T5Wv-Tnvocxh@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

(Maybe this question would be more suitable for the pgsql-performance list?)

TIA!

~kynn

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Geoghegan 2010-10-16 15:39:13 Re: Fastest way to check database's existence
Previous Message Tom Lane 2010-10-16 13:44:16 Re: Request for comment: pgjson project