Fernando Nasser <[EMAIL PROTECTED]> writes: > Christopher Kings-Lynne wrote: >> You know, I'm kinda surprised that the spec doesn't define a CURRENT_SCHEMA >> variable you can query???
> Maybe because it would be the same as CURRENT_USER. It'd probably make sense for us to have one, though, given that I'm intent on not hardwiring the two concepts together as the spec does ;-). Although you can interrogate the search path with SHOW, that's not very accessible at the SQL level, so an SQL function seems useful too. I'd be inclined to make CURRENT_SCHEMA return the name of the schema that is the default creation target namespace (viz, the front of the search path). Thoughts? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html