Choose your SQL server:
AnySQL
MySQL
MS SQL Server
PostgreSQL
Oracle
SQL Anywhere
DB2
SQLite
Firebird
MaxDB

Subscribe to our newsletter

PostgreSQL Maestro online Help

Prev  Return to chapter overview Next 

Editing tablespace properties

Tablespace Editor provides you with an ability to edit tablespace properties.

 

 

Name

Here you can change the tablespace name.

 

Owner

It is possible to change the tablespace owner in this field.

 

OID

The tablespace OID (object identifier) is stored in this field. This is a serial number that is automatically added by PostgreSQL to all tablespaces. The OID is read-only.

 

Location

The field value indicates the directory where the tablespace is located.

 

To apply the changes, select the Apply Changes item in the Navigation bar or use Ctrl+F9 or Ctrl+F7 shortcut keys.

 

It is also possible to modify object properties without opening the object editor: use the Object Properties item of the popup menu of the selected object from the explorer tree.



Prev  Return to chapter overview Next