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
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
