Paweł Domański
16 lines
359 B
SQL
16 lines
359 B
SQL
CREATE TABLESPACE:
|
|
postgres=# create tablespace ts_postgres location '/Library/PostgreSQL/TEST/TS_POSTGRES';
|
|
CREATE TABLESPACE
|
|
|
|
RENAME TABLESPACE:
|
|
postgres=# alter tablespace ts_postgres rename to ts_dbaclass;
|
|
ALTER TABLESPACE
|
|
|
|
DROP TABLESPACE:
|
|
|
|
postgres=# drop tablespace ts_dbaclass;
|
|
DROP TABLESPACE
|
|
|
|
|
|
|
|
<<Before dropping tablespace make sure it is emptry>> |