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

Categories

DDL, GUC configuration item, Storage, Tablespaces

See also

temp_tablespaces, tablespace, pg_tablespace