Re: pl sql to check if table of table_name exists - Mailing list pgsql-general

From Shaun Clements
Subject Re: pl sql to check if table of table_name exists
Date
Msg-id 100F78F2B203444BB161BBA7077FF6131CD89E@srldbexc003.relyant.co.za
Whole thread Raw
List pgsql-general
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>
 
A {FONT-FAMILY: verdana; TEXT-DECORATION: none } A:active {COLOR: #ff0000; FONT-FAMILY: verdana; TEXT-DECORATION: none } A:link {COLOR: #003366; FONT-FAMILY: verdana; TEXT-DECORATION: none } A:visited {COLOR: #003366; FONT-FAMILY: verdana; TEXT-DECORATION: none } A:hover {COLOR: #ff0000; FONT-FAMILY: verdana; TEXT-DECORATION: underline } .small_text {FONT-SIZE: 9px; COLOR: #003366; FONT-FAMILY: verdana } Kind Regards,
Shaun Clements
 
 
 -----Original Message-----
From: Sim Zacks [mailto:sim@compulab.co.il]
Sent: 10 March 2005 01:24 PM
To: pgsql-general@postgresql.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@compulab.co.il> wrote in message news:d0pamh$2l83$1@news.hub.org...
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: "Sim Zacks"
Date:
Subject: Re: pl sql to check if table of table_name exists
Next
From: Janning Vygen
Date:
Subject: normal user dump gives error because of plpgsql