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.
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.