Does SELECT INTO is affected by default_tablespace?

From: "Qingqing Zhou" <zhouqq(at)cs(dot)toronto(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: Does SELECT INTO is affected by default_tablespace?
Date: 2005-05-24 06:04:23
Message-ID: d6ug91$15hg$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Browse pgsql-general by date

  From Date Subject
Next Message Typing80wpm 2005-05-24 06:44:39 unsubscribe
Previous Message Surabhi Ahuja 2005-05-24 05:13:25 bigserial coloumn