How To Create Tablespace On PostgreSQL

We should need to create tablespace on postgresql sometimes.

I recommend to create a new tablespace when you create a database. Do not use default tablespace any time.

You can create tablespace with below command.

x	your tablespace name
testuser	who is the owner of the tablespace
/x/pg_data/	location of the tablespace

create tablespace x owner testuser location '/x/pg_data/';

1	create tablespace x owner testuser location '/x/pg_data/';

Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux