PostgreSQL Writer: User Attributes

For information on the parameters in this dialog that are specific to all formats, see About Writer Feature Types: User Attributes

User attributes for this format are defined below.

Name

The name of the column to be written. Valid values for column name include any character string devoid of SQL offensive characters and less than 32 characters in length.

Type

The type of a column in a table. The valid values for the column type are listed below:

Index

The type of index to create on the given column. All index types are fully dynamic and do not have to be optimized periodically. The valid values for the index type are listed below:

  • BTREE: This type of index is an implementation of Lehman-Yao high-concurrency btrees. Only this type supports multi-column indices. Up to 16 keys may be specified by default.
  • RTREE: This type of index is an implementation of standard rtrees using Guttamn’s quadratic split algorithm.
  • HASH: This type of index is an implementation of Litwin’s linear hashing.
  • PRIKEY: This type of index specifies that the column is a primary key. The values in this column cannot be NULL.