Re: pl sql to check if table of table_name exists

From: "Sim Zacks" <sim(at)compulab(dot)co(dot)il>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: pl sql to check if table of table_name exists
Date: 2005-03-10 11:21:09
Message-ID: d0pamh$2l83$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

RE: [GENERAL] pl sql to check if table of table_name existsselect your_tablename from pg_class where relkind='r'
"Shaun Clements" <ShaunC(at)relyant(dot)co(dot)za> wrote in message news:100F78F2B203444BB161BBA7077FF6131CD89C(at)srldbexc003(dot)relyant(dot)co(dot)za(dot)(dot)(dot)
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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sim Zacks 2005-03-10 11:24:05 Re: pl sql to check if table of table_name exists
Previous Message go 2005-03-10 10:03:04 Locale problem