Finding if a temp table exists in the current connection

Поиск
Список
Период
Сортировка
От Mike Papper
Тема Finding if a temp table exists in the current connection
Дата
Msg-id b6ff90$24ap$1@news.hub.org
обсуждение исходный текст
Список pgsql-sql
Is there a way (i.e., access theinternal pg_ tables) to find out if a 
particular temp table already exists (in the current connection)?

I have written some stored procedures that check if a table exists and if a 
column exists in a table. This is used so I can perform upgrades of our 
system (if table doesnt exist, call create table... sql).

I would like to do a similar thing for temp tables.

I have noticed that if another connection creates a temp table, it will 
show up in the pg_* tables so that all ocnnections can see the table.

Is there some standard SQL way to test?

-- 
Mike Papper



В списке pgsql-sql по дате отправления:

Предыдущее
От: antti.ijas@arcada.fi (Antti Ijäs)
Дата:
Сообщение: Foreign key from another database
Следующее
От: "Hugh Krenske"
Дата:
Сообщение: auto-commit