Hi, How to set such variable after (during?) client connection (PHP)? I want to use it in view - so view could depends on it: If I could set client's variable i.e. MY_VAR='hello' then I could do something like this: CREATE VIEW my_view AS SELECT * FROM pg_tables WHERE tablename ~* (SELECT MY_VAR FROM ???) Cheers! ___ fryk ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match