Re: [GENERAL] Fastest way to check database's existence

2010-10-17 Thread Kynn Jones
Thank you all for your comments and suggestions! ~kj

Re: [GENERAL] Fastest way to check database's existence

2010-10-16 Thread Adrian Klaver
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 (wit

Re: [GENERAL] Fastest way to check database's existence

2010-10-16 Thread Raymond O'Donnell
On 16/10/2010 16:13, 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 th

Re: [GENERAL] Fastest way to check database's existence

2010-10-16 Thread Peter Geoghegan
> 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?) No. You have to connect to some database in particular to do anything. That's why the postgres databas

[GENERAL] Fastest way to check database's existence

2010-10-16 Thread Kynn Jones
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