Bom dia, Euler.
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)
Red Hat -> Fedora 10
Inseri uma linha e ...
dmonitor=> insert into whattbs(id) values(1);
INSERT 17464 1
dmonitor=>
dmonitor=> select tablename, tablespace from pg_tables where
tablename='whattbs';
tablename | tablespace
-----------+------------
whattbs |
(1 row)
Att.,
Sergio Nogueira
2009/6/20 Euler Taveira de Oliveira <[email protected]>
> sergio nogueira escreveu:
> > Em que tablespace está a tabela?
> >
> Funciona aqui. Qual versão?
>
> psql (8.4beta2)
> Digite "help" para ajuda.
>
> euler=# \! mkdir /tmp/foo
> euler=# create tablespace footbs location '/tmp/foo';
> CREATE TABLESPACE
> euler=# create table foo (a int);
> CREATE TABLE
> euler=# insert into foo select generate_series(1, 10);
> INSERT 0 10
> euler=# select tablename,tablespace from pg_tables where tablename='foo';
> tablename | tablespace
> -----------+------------
> foo |
> (1 row)
>
> euler=# alter table foo set tablespace footbs;
> ALTER TABLE
> euler=# select tablename,tablespace from pg_tables where tablename='foo';
> tablename | tablespace
> -----------+------------
> foo | footbs
> (1 row)
>
>
> --
> Euler Taveira de Oliveira
> http://www.timbira.com/
> _______________________________________________
> pgbr-geral mailing list
> [email protected]
> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
>
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
