Frank van Vugt <[EMAIL PROTECTED]> writes:
>> After you've created at least one temp table, you can look at the result
>> of "current_schemas(true)".  There's no guarantee that the schema even
>> exists before you've created something...

> Is there a guaranteed order of the resulting array, i.e. is this guaranteed 
> to 
> return the temp schema, given there is one:

>       'select (current_schemas(true))[1]'.....?

Yes, in the current implementation and for the foreseeable future (else
temp tables would fail to mask permanent tables).

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq

Reply via email to