Re: checking for existence of a table in plpgsql. - Mailing list pgsql-sql

From Roberto Mello
Subject Re: checking for existence of a table in plpgsql.
Date
Msg-id 20020314162834.GA22202@cc.usu.edu
Whole thread Raw
In response to checking for existence of a table in plpgsql.  (Bhuvan A <bhuvansql@yahoo.com>)
List pgsql-sql
On Thu, Mar 14, 2002 at 11:10:35AM +0530, Bhuvan A wrote:
> 
> hi,
> 
> here i use postgresql 7.2.
> 
> how can one know that a particular table exists or not in plpgsql?
> 
> need is something like this.. 
> from plpgsql, i wish to insert a record in a table (create and insert,
> if not exists).

Besides what was already pointed out, I remember seeing some function to
check for existance of several things in the Cookbook:
http://www.brasileiro.net/postgres/cookbook/

-Roberto

-- 
+----| http://fslc.usu.edu/ USU Free Software & GNU/Linux Club |------+ Roberto Mello - Computer Science, USU -
http://www.brasileiro.net/      http://www.sdl.usu.edu/ - Space Dynamics Lab, Developer    
 
Once upon a time there was 3 little pigs, P1, P2 and P3


pgsql-sql by date:

Previous
From: Bo Lorentsen
Date:
Subject: Re: Large data sets and FOR LOOP's
Next
From: Jie Liang
Date:
Subject: unable to log