* Gnanakumar wrote:
We're using PostgreSQL v8.2.3.
How do I get the schema name in which TEMPORARY table is created using
CREATE TEMP TABLE mytable syntax?
SELECT nspname FROM pg_namespace WHERE oid = pg_my_temp_schema();
I don't have an 8.2.3 lying around, but git says that function
Hi,
We're using PostgreSQL v8.2.3.
How do I get the schema name in which TEMPORARY table is created using
CREATE TEMP TABLE mytable syntax?
In our application, we're creating temporary table with the same as an
existing permanent table which is available in public schema. Hence, I
want to
select n.nspname from pg_class c join pg_namespace n on
n.oid=c.relnamespace
where c.relname ='foo' and n.nspname like 'pg_temp%';
This will return all the schema name that are available which were created
using TEMP TABLE syntax. Since our application is web-based, of course,
there will be
Gnanakumar gna...@zoniac.com writes:
We're using PostgreSQL v8.2.3.
How do I get the schema name in which TEMPORARY table is created using
CREATE TEMP TABLE mytable syntax?
Do you need the real schema name, or will the pg_temp alias be
sufficient?
regression=# create temp table foo(f1
How do I get the schema name in which TEMPORARY table is created using
CREATE TEMP TABLE mytable syntax?
Do you need the real schema name, or will the pg_temp alias be
sufficient?
I need the real schema name (for example, pg_temp_xxx) in which it is
created and not just the alias.
--