From: Steve Boyle \(Roselink\) <boylesa@roselink.co.uk>
To: D'laila Pereira <dpereira@students.uiuc.edu>
To: pgsql-sql@postgresql.org
Subject: Re: test the existence of a database
Date: Sat, 2 Feb 2002 16:38:15 -0000
Message-ID: <005101c1ac08$02f3ea20$c55869d5@dualtower> (raw)
References: <Pine.GSO.4.31.0201311451080.6396-100000@ux11.cso.uiuc.edu>
D'laila,
you could write a function in plpgsql that queried the postgres catalogues
for the object that you were interested in an returned true of false if the
object existed.
For an example see:
http://www.brasileiro.net/postgres/cookbook/view-one-recipe.adp?recipe_id=14
23
hih
steve boyle
----- Original Message -----
From: "D'laila Pereira" <dpereira@students.uiuc.edu>
To: <pgsql-sql@postgresql.org>
Sent: Thursday, January 31, 2002 8:52 PM
Subject: [SQL] test the existence of a database
>
> After a database is created in postgresql using the createdb command,
> and populate it with some taqbles, how do we test the existence of the
> database and the tables within it?
>
> thanks
> d'laila
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: boylesa@roselink.co.uk, dpereira@students.uiuc.edu
Subject: Re: test the existence of a database
In-Reply-To: <005101c1ac08$02f3ea20$c55869d5@dualtower>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox