| 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:24:05 |
| Message-ID: | d0pas2$2mbj$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 existsi mean
select * from pg_class where relkind='r' and relname=your_tablename
"Sim Zacks" <sim(at)compulab(dot)co(dot)il> wrote in message news:d0pamh$2l83$1(at)news(dot)hub(dot)org(dot)(dot)(dot)
select 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shaun Clements | 2005-03-10 11:27:46 | Re: pl sql to check if table of table_name exists |
| Previous Message | Sim Zacks | 2005-03-10 11:21:09 | Re: pl sql to check if table of table_name exists |