am Mon, dem 15.01.2007, um 13:18:11 +0100 mailte Moritz Bayer folgendes: > Dear list, > > I would like to create a function which gets a tablename and checks if the > specific table exists.The return value should be a bool. > Now I'm wondering how to do this the best way. > > Any suggestions?
You can ask pg_tables:
select count(1) from pg_tables where tablename = 'foo' and schemaname = 'public';
This ask for a table called 'foo' in the schema 'public'.
Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net
---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives?