Re: pl sql to check if table of table_name exists

Hi Sim

Thanks for your response. I had it working from a previous post by Adam
Tomjack.
<snip>
-- A list of tables:

SELECT schemaname, tablename FROM pg_tables;

-- Returns true if a table exists:

SELECT count(*)>0 FROM pg_tables

WHERE schemaname='...' AND tablename='...'

</snip>


Your response does not work for me. Perhaps you can explain the posted
command

<snip>
* from pg_class where relkind='r' and relname=your_tablename
</snip>

Kind Regards,
Shaun Clements

-----Original Message-----
From: Sim Zacks [mailto:sim(at)compulab(dot)co(dot)il]
Sent: 10 March 2005 01:24 PM
To: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] 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(at)compulab(dot)co(dot)il <mailto:sim(at)compulab(dot)co(dot)il> > wrote in
message news:d0pamh$2l83$1(at)news(dot)hub(dot)org <news:d0pamh$2l83$1(at)news(dot)hub(dot)org>
...
select your_tablename from pg_class where relkind='r'

"Shaun Clements" < ShaunC(at)relyant(dot)co(dot)za <mailto:ShaunC(at)relyant(dot)co(dot)za> >
wrote in message
news:100F78F2B203444BB161BBA7077FF6131CD89C(at)srldbexc003(dot)relyant(dot)co(dot)za
<news:100F78F2B203444BB161BBA7077FF6131CD89C(at)srldbexc003(dot)relyant(dot)co(dot)za> ...

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