"J. Carlos Muro" <murojc@xxxxxxxxx> writes: > I have created a tablespace and a database in that tablespace: > create tablespace tb_user location '/data/tb_user'; > create database mydatabase tablespace "tb_user"; > \c mydatabase; > create table a_table (id bigint, name text); > I supposed that "a_table" should be in the tablespace "tb_user" as the > database was created to use it by default. But I doesnt seem like that when > i state the next: The database's default tablespace is never named explicitly in pg_tables nor in the underlying pg_class catalog. This is intentional to make it easier to move a database to a different default tablespace. regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
