creating tables in tablespace

Hi,
I'm not able to create tables in a specific tablespace. I'm not sure what I
have missed.

According to the documentation, a table can be created in a specific
tablespace by performing the following:
1. Specify the tablespace parameter in the create database statement.
2. Specify the tablespace parameter in the create table statement.

I've tried both but the tablespace column in pg_tables is empty. "show
default_tablespace" is also empty. Can someone help?

Thanks.

As the superuser,
create tablespace mytablespace owner myuser location '/pgsqldata/mydb';
create database mydb owner=myuser tablespace=mytablespace;

As myuser,
mydb=> select current_user;
current_user
--------------
myuser
(1 row)

mydb=> create table tab1 (a int);
CREATE TABLE
mydb=> create table tab2 (a int) tablespace mytablespace;
CREATE TABLE
mydb=> show default_tablespace;
default_tablespace
--------------------

(1 row)

mydb=> select tablename,tableowner,tablespace from pg_tables where
tablename like 'tab%';
tablename | tableowner | tablespace
-----------+------------+------------
tab1 | myuser |
tab2 | myuser |
(2 rows)