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
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
On 1 November 2010 10:46, Thomas Kellerer spam_ea...@gmx.net 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
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
On Mon, Nov 1, 2010 at 6:46 AM, Thomas Kellerer spam_ea...@gmx.net 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
Merlin Moncure wrote on 01.11.2010 21:13:
On Mon, Nov 1, 2010 at 6:46 AM, Thomas Kellererspam_ea...@gmx.net 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
On Mon, Nov 1, 2010 at 4:27 PM, Thomas Kellerer spam_ea...@gmx.net 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
On 11/01/2010 04:13 PM, Merlin Moncure wrote:
On Mon, Nov 1, 2010 at 4:27 PM, Thomas Kellerer spam_ea...@gmx.net 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 Moncure wrote on 01.11.2010 23:13:
On Mon, Nov 1, 2010 at 4:27 PM, Thomas Kellererspam_ea...@gmx.net 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