3.28. Tablespaces

Tablespaces are used to allocate in the filesystem an alternative location where the data files containing database objects (like tables and indexes) can reside. Only superusers have the privileges to create tablespaces on the server, however once created a tablespace it can have the ownership changed to another user.

Attribute Description
Directory A valid and already existent path in server where the tablespace will be created.

** Tablespace DDL **

https://www.postgresql.org/docs/current/static/sql-createtablespace.html

Jan 3, 2020 at 12:33