Ken Tanzer <ken.tanzer@xxxxxxxxx> writes: > One thing about the search path though, regarding pg_temp. If I add a > SET search_path = public; > Do I need instead to specify "public, pg_temp" to prevent it from being > (silently) at the beginning? Yeah, that would be slightly safer. If the public schema is world-writable, though, you're in big trouble anyway ... regards, tom lane