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 //