PostgreSQL Discussion - Does SELECT INTO is affected by default

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Does SELECT INTO is affected by default_tablespace?

Qingqing Zhou

2005-05-24, 3:23 am

According to my test, it does not:

test=# set default_tablespace = testsp;
SET
test=# create table a (i int);
CREATE TABLE
test=# select * into b from a;
SELECT
test=# \d+ b
Table "public.b"
Column | Type | Modifiers | Description
--------+---------+-----------+-------------
i | integer | |
Has OIDs: yes

test=# \d+ a
Table "public.a"
Column | Type | Modifiers | Description
--------+---------+-----------+-------------
i | integer | |
Has OIDs: yes
Tablespace: "testsp"

If so, shall we fix it?

Regards,
Qingqing

Sponsored Links