Thanks! very useful for me!
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Temporary-schemas-tp3244865p5742352.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
Merlin Moncure wrote on 01.11.2010 23:13:
On Mon, Nov 1, 2010 at 4:27 PM, Thomas Kellerer wrote:
The problem is, that the JDBC driver only returns information about the temp
tables, if I specify that schema directly.
Have you filed a bug report to jdbc yet? :-D.
I thought about it initially
On 11/01/2010 04:13 PM, Merlin Moncure wrote:
> On Mon, Nov 1, 2010 at 4:27 PM, Thomas Kellerer wrote:
>> The problem is, that the JDBC driver only returns information about the temp
>> tables, if I specify that schema directly.
>
> Have you filed a bug report to jdbc yet? :-D.
>
> merlin
>
On Mon, Nov 1, 2010 at 4:27 PM, Thomas Kellerer wrote:
> The problem is, that the JDBC driver only returns information about the temp
> tables, if I specify that schema directly.
Have you filed a bug report to jdbc yet? :-D.
merlin
--
Sent via pgsql-general mailing list (pgsql-general@postgres
Merlin Moncure wrote on 01.11.2010 21:13:
On Mon, Nov 1, 2010 at 6:46 AM, Thomas Kellerer wrote:
Hello,
I have created a temporary table using
create temporary table foo
(
id integer
);
and noticed this was created in a schema called "pg_temp_2"
My question is:
is this always "pg_temp_2"
On Mon, Nov 1, 2010 at 6:46 AM, Thomas Kellerer wrote:
> Hello,
>
> I have created a temporary table using
>
> create temporary table foo
> (
> id integer
> );
>
> and noticed this was created in a schema called "pg_temp_2"
>
> My question is:
>
> is this always "pg_temp_2"?
> Or will the name of
Thom Brown wrote on 01.11.2010 12:33:
You can use:
SELECT nspname
FROM pg_namespace
WHERE oid = pg_my_temp_schema();
to get the name of the current temporary schema for your session.
Thanks that's what I was looking for.
Regards
Thomas
--
Sent via pgsql-general mailing list (pgsql-gene
On 1 November 2010 10:46, Thomas Kellerer wrote:
> Hello,
>
> I have created a temporary table using
>
> create temporary table foo
> (
> id integer
> );
>
> and noticed this was created in a schema called "pg_temp_2"
>
> My question is:
>
> is this always "pg_temp_2"?
> Or will the name of the
Hello,
I have created a temporary table using
create temporary table foo
(
id integer
);
and noticed this was created in a schema called "pg_temp_2"
My question is:
is this always "pg_temp_2"?
Or will the name of the "temp schema" change?
If it isn't always the same, is there a way I can r