On Mon, 13 May 2002, Vincent Stoessel wrote:
> Is there an sql query that I can use on postgres that will tell
> me if a table exists?
SELECT COUNT(1) FROM pg_tables WHERE tablename='whatever';
For more information, type \dS in your psql client. It will show you
the many system tables that contain information and various sundry
things about your postgres database/installation.
--
+-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-+
| Shaun M. Thomas INN Database Administrator |
| Phone: (309) 743-0812 Fax : (309) 743-0830 |
| Email: sthomas@townnews.com AIM : trifthen |
| Web : www.townnews.com |
| |
| "Most of our lives are about proving something, either to |
| ourselves or to someone else." |
| -- Anonymous |
+-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-+
