Re: [GENERAL] pl sql to check if table of table_name exists

[Sim Zacks]

Title: RE: [GENERAL] pl sql to check if table of table_name exists

i mean select * from pg_class where relkind='r' and relname=your_tablename "Sim Zacks" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]... select your_tablename from pg_class where relkind='r' "Shaun Clements" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]... Hi Hate to ask, but it isnt obvious to me from the documentation. How do I perform a query in pgplsql, to check it a table exists of a particular name. Thanks in advance Kind Regards, Shaun Clements