Re: pl sql to check if table of table_name exists

[Shaun Clements <ShaunC@xxxxxxxxxxxxx>]

Title: 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@xxxxxxxxxxxxxx]
Sent: 10 March 2005 01:24 PM
To: pgsql-general@xxxxxxxxxxxxxx
Subject: Re: 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@xxxxxxxxxxxxxx> wrote in message news:d0pamh$2l83$1@xxxxxxxxxxxx...

select your_tablename from pg_class where relkind='r'

"Shaun Clements" <ShaunC@xxxxxxxxxxxxx> wrote in message news:100F78F2B203444BB161BBA7077FF6131CD89C@xxxxxxxxxxxxxxxxxxxxxxxxx...

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