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