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

From Bhuvan A
Subject checking for existence of a table in plpgsql.
Date
Msg-id Pine.LNX.4.20.0203141101100.32557-100000@Larry
Whole thread Raw
Responses Re: checking for existence of a table in plpgsql.
Re: checking for existence of a table in plpgsql.
List pgsql-sql
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).

---

create function ftest()
returns int as 'declare

begin
 if <table exists> then   insert into <table> (...) values (...); else   create <table> (...);   insert into <table>
(...)values (...); end if;  return row_count;
 
end;'
language 'plpgsql';

----

hope to get some lights.

Regards,
Bhuvaneswaran.




pgsql-sql by date:

Previous
From: Herbert Rabago Ambos
Date:
Subject: Re: [INIMSS] How to use OID?
Next
From: Bo Lorentsen
Date:
Subject: Re: Large data sets and FOR LOOP's