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 |
Description |
Standard |
A normal table resides in the database in the specified tablespace.
|
Foreign |
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.