Re: check table existence...

Shoaib Mir wrote:
> Something like this will help you......

Or shorter:

> =======================
>
> CREATE OR REPLACE FUNCTION public.check_table(varchar, varchar)
> RETURNS boolean AS $$
> DECLARE
>   v_cnt integer;
>   v_tbl boolean;
> BEGIN

   PERFORM 1 FROM pg_tables where tablename = $1 and

> schemaname = $2;

   RETURN FOUND;

> END;
>  $$ LANGUAGE 'plpgsql'

I'm pretty sure that should work.

--
Alban Hertroys
alban@magproductions.nl

magproductions b.v.

T: ++31(0)534346874
F: ++31(0)534346876
M:
I: www.magproductions.nl
A: Postbus 416
   7500 AK Enschede

// Integrate Your World //