Thread: 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 ...

From
Benoît Bournon
Date:
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 ;