Sorry: I forgot to add something to option 2
--- "ON.KG" <__> wrote:
> Hi ALL!
>
> I need to check before selection records from table - does this table
> exist
> How can i do that?
>
> Thanx in advance
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to
> majordomo@postgresql.org
>
Option 1: tells you if the table exists in your database
select *
from pg_catalog.pg_tables as t
where t.schemaname = '<your schema name>' and
t.tablename = '<your table name';
Option 2: tells you if the table exists in your database and if is
visible in your search path (i.e. no need to select * from
schema.table, only select * from table)
select *
from pg_catalog.pg_class as c left outer join
pg_catalog.pg_namespace as n on
n.oid = c.relnamespace
where n.nspname = '<your schema name>' and
c.relname = '<your table name' and
c.relkind = 'r' and
pg_catalog.pg_table_is_visible(c.oid);