> Suppose, one server/postmaster is running several databases. Is there > something like "SET database TO whatever" (and I mean *database* not > schema). I need this to ensure that a script runs only against db for > which it was desinged.
You can use PG* environment variables if you wish to write seperate script for each databases. regards, bhuvaneswaran ---------------------------(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