where is the table?

From: sergio nogueira <sergiopnog(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: where is the table?
Date: 2009-06-20 14:10:45
Message-ID: eec843740906200710n239c3354j9816392c2cbd0855@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi, all.

Where is the table?

dmonitor=> create table wereisthetable(col int);
CREATE TABLE
dmonitor=> select tablename, tablespace from pg_tables where
tablename='wereisthetable';
tablename | tablespace
----------------+------------
wereisthetable |
(1 row)

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

dmonitor=> select version();

version
------------------------------------------------------------------------------------------------------------
PostgreSQL 8.4rc1 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.3.2
20081105 (Red Hat 4.3.2-7), 32-bit
(1 row)

Att.,
Sergio

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2009-06-20 19:37:32 Re: pl/sql resources for pl/pgsql?
Previous Message benoît carpentier 2009-06-20 14:09:17 Benetl, a free ETL tool for files using postgreSQL, is out in version 2.8