Re: pl sql to check if table of table_name exists

["Sim Zacks" <sim@xxxxxxxxxxxxxx>]

Title: RE: 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" <sim@xxxxxxxxxxxxxx> wrote in message news:d0pamh$2l83$1@xxxxxxxxxxxx...

select your_tablename from pg_class where relkind='r'

"Shaun Clements" <ShaunC@xxxxxxxxxxxxx> wrote in message news:100F78F2B203444BB161BBA7077FF6131CD89C@xxxxxxxxxxxxxxxxxxxxxxxxx...

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