Postgres Pro
Downloads
Home   >   mailing lists

Re: pl sql to check if table of table_name exists - Mailing list pgsql-general

From Sim Zacks
Subject Re: pl sql to check if table of table_name exists
Date
Msg-id d0pas2$2mbj$1@news.hub.org
Whole thread Raw
In response to Re: pl sql to check if table of table_name exists  (Shaun Clements <ShaunC@relyant.co.za>)
List pgsql-general
Tree view
i mean
select * from pg_class where relkind='r' and relname=your_tablename
"Sim Zacks" <sim@compulab.co.il> wrote in message news:d0pamh$2l83$1@news.hub.org...
select your_tablename from pg_class where relkind='r'

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

pgsql-general by date:

Previous
From: "Sim Zacks"
Date:
Subject: Re: pl sql to check if table of table_name exists
Next
From: Shaun Clements
Date:
Subject: Re: pl sql to check if table of table_name exists