How to specify tablespace when creating postgres database?

Question

My postgres server is running out of space when restoring database, after dumping, How can I create a tablespace and specify a new database to that specific location.

Some examples would be nice. Thanks

Answer 1

PostgreSQL CREATE TABLESPACE statement

create database dbname with tablespace = tablespace_name;