Table Editor Options

Previous  Index  Next  How To Use

The Options tab lists the available options when creating a new table.


PostgreSQL Table Options


PostgreSQL offers 2 table types: Standard and Foreign.


Table Type



A normal table resides in the database in the specified tablespace.



A foreign table is a table on another database server, linked via a Remote Server registration. It maps to an existing table.


Standard Table Options

Besides a primary key name, the tablespace (you can also set a specific tablespace when you create the database, but this can be overridden at the table level), and "fill factor", you can also use custom auto-vacuum options for each table.


Use the Use custom auto-vacuum options checkbox to override the default options.


Foreign Table Options



In order to create a mapping to a foreign table, you need to specify a remote server, registered for this database, and additional options, that are remote server provider specific.