In this article, we will see How to create tablespace in PostgreSQL with examples and other actions can be performed related to PostgreSQL tablespace.
What is PostgreSQL tablespace?
A tablespace is a location on the disk where PostgreSQL stores data files containing database objects e.g., tables, and indexes. PostgreSQL uses a tablespace to map a logical name to a physical location on disk.
PostgreSQL comes with two default tablespaces:
pg_default tablespace stores user data.
pg_global tablespace stores global data.
Syntax to Create PostgreSQL Tablespace:
CREATE TABLESPACE tablespace_name [ OWNER owner_name] LOCATION 'directory'
Continue reading How to create tablespace in PostgreSQL with examples