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 d0pamh$2l83$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
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: go
Date:
Subject: Locale problem
Next
From: "Sim Zacks"
Date:
Subject: Re: pl sql to check if table of table_name exists