Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group