Обсуждение: How can I use a name of table in attribute of function, I try PREPARE ...

Поиск
Список
Период
Сортировка

How can I use a name of table in attribute of function, I try PREPARE ...

От
Benoît Bournon
Дата:
I can do that on PostgreSQL 7.3 ??



Is it possible to do that ? or must I upgrade my server ??


PREPARE q1(text) FROM SELECT * FROM pg_tables WHERE tablename = $1 ;
EXECUTE q1 USING 'client' ;

DEALLOCATE q1 ;