Re: Fwd: alter table ... set tablespace

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: sergio nogueira <sergiopnog(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Fwd: alter table ... set tablespace
Date: 2009-06-20 15:21:50
Message-ID: 3773.1245511310@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

sergio nogueira <sergiopnog(at)gmail(dot)com> writes:
> 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?

It's probably in the default tablespace for the current database.

regards, tom lane

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Kevin Duffy 2009-06-21 16:41:19 Re: level of recursion
Previous Message sergio nogueira 2009-06-20 12:21:11 Fwd: alter table ... set tablespace