Fwd: alter table ... set tablespace

From: sergio nogueira <sergiopnog(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Fwd: alter table ... set tablespace
Date: 2009-06-20 12:21:11
Message-ID: eec843740906200521m5277d94ey602e083b6621ad5d@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi, i didn't understand:

dmonitor=> create table whattbs (id integer);
CREATE TABLE
dmonitor=> select tablename, tablespace from pg_tables where
tablename='whattbs';
tablename | tablespace
-----------+------------
whattbs |
(1 row)

dmonitor=> alter table whattbs set tablespace monitor_dat1;
ALTER TABLE
dmonitor=> select tablename, tablespace from pg_tables where
tablename='whattbs';
tablename | tablespace
-----------+------------
whattbs |
(1 row)

In what tablespace is the table?

Att.,
Sergio Nogueira

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2009-06-20 15:21:50 Re: Fwd: alter table ... set tablespace
Previous Message Tom Lane 2009-06-19 22:03:50 Re: level of recursion