default_tablespace
A configuration parameter specifying the default tablespace
default_tablespace is a configuration parameter specifying the default tablespace in which to create database objects.
default_tablespace was added in PostgreSQL 8.0.
Default value
The default value for default_tablespace is: '' (empty string)
Usage
If not set (the default), objects are created in the database's default tablespace.
If set to a specific tablespace, objects will be created in that tablespace (provided the user has the CREATE privilege for that tablespace.
Change history
- PostgreSQL 8.0
- added (commit 98e8b480)
References
- PostgreSQL documentation: default_tablespace