Re: check table existence...

Thanks, that's exactly what I was looking for :-)

kind regards,
Morirt

2007/1/15, A. Kretschmer <andreas(dot)kretschmer(at)schollglas(dot)com>:
>
> 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?
>
> http://archives.postgresql.org/
>