pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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
>




view thread (4+ messages)  latest in thread

Message-ID: <005101c1ac08$02f3ea20$c55869d5@dualtower>
Permalink:  ../005101c1ac08$02f3ea20$c55869d5@dualtower/
Also on:    postgresql.org/message-id/005101c1ac08$02f3ea20$c55869d5@dualtower

 · 

reply

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