Re: pg_castalog.pg_tables does not show the real tablespace for tables

"J. Carlos Muro" <murojc(at)gmail(dot)com> 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