java.lang.Object

java.lang.Enum<TableColumnType>

com.northconcepts.datapipeline.sql.postgresql.TableColumnType

All Implemented Interfaces:: Serializable, Comparable<TableColumnType>, Constable

public enum TableColumnType extends Enum<TableColumnType>

PostgreSQL column data types for CreateTableColumn, noting which accept a length and a scale.

Nested Class Summary

Nested classes/interfaces inherited from class java.lang.Enum
Enum.EnumDesc<E extends Enum<E>>
Enum Constant Summary

Enum Constants

Enum Constant

Description

BIGINT

BIGSERIAL

BIT

BIT_VARYING

BOOL

BOOLEAN

BOX

BYTEA

CHAR

CHARACTER

CHARACTER_VARYING

CIDR

CIRCLE

DATE

DECIMAL

DOUBLE_PRECISION

FLOAT4

FLOAT8

INET

INT

INT2

INT4

INT8

INTEGER

JSON

JSONB

LINE

LSEG

MACADDR

MACADDR8

MONEY

NUMERIC

PATH

PG_LSN

PG_SNAPSHOT

POINT

POLYGON

REAL

SERIAL

SERIAL2

SERIAL4

SERIAL8

SMALLINT

SMALLSERIAL

TEXT

TIME

TIME_WITH_TIME_ZONE

TIME_WITHOUT_TIME_ZONE

TIMESTAMP

TIMESTAMP_WITH_TIME_ZONE

TIMESTAMP_WITHOUT_TIME_ZONE

TIMESTAMPTZ

TIMETZ

TSQUERY

TSVECTOR

TXID_SNAPSHOT

UUID

VARBIT

VARCHAR

XML
Method Summary

Modifier and Type

Method

Description

String

getSqlFragment()

Returns the type as written in SQL: the lowercase name with spaces for underscores (e.g.

boolean

isLengthSupported()

Indicates if a length or precision may follow this type in a column definition.

boolean

isScaleSupported()

Indicates if a scale may follow the length or precision of this type in a column definition.

static TableColumnType

valueOf(String name)

Returns the enum constant of this class with the specified name.

static TableColumnType[]

values()

Returns an array containing the constants of this enum class, in the order they are declared.

Methods inherited from class java.lang.Enum
clone, compareTo, describeConstable, equals, finalize, getDeclaringClass, hashCode, name, ordinal, toString, valueOf

Methods inherited from class java.lang.Object
getClass, notify, notifyAll, wait, wait, wait

Enum Constant Details
- BIGINT
  
  public static final TableColumnType BIGINT
- BIGSERIAL
  
  public static final TableColumnType BIGSERIAL
- BIT
  
  public static final TableColumnType BIT
- BIT_VARYING
  
  public static final TableColumnType BIT_VARYING
- VARBIT
  
  public static final TableColumnType VARBIT
- BOOLEAN
  
  public static final TableColumnType BOOLEAN
- BOOL
  
  public static final TableColumnType BOOL
- BOX
  
  public static final TableColumnType BOX
- BYTEA
  
  public static final TableColumnType BYTEA
- CHAR
  
  public static final TableColumnType CHAR
- CHARACTER
  
  public static final TableColumnType CHARACTER
- CHARACTER_VARYING
  
  public static final TableColumnType CHARACTER_VARYING
- VARCHAR
  
  public static final TableColumnType VARCHAR
- CIDR
  
  public static final TableColumnType CIDR
- CIRCLE
  
  public static final TableColumnType CIRCLE
- DATE
  
  public static final TableColumnType DATE
- DOUBLE_PRECISION
  
  public static final TableColumnType DOUBLE_PRECISION
- FLOAT4
  
  public static final TableColumnType FLOAT4
- FLOAT8
  
  public static final TableColumnType FLOAT8
- INET
  
  public static final TableColumnType INET
- INT
  
  public static final TableColumnType INT
- INT4
  
  public static final TableColumnType INT4
- INT2
  
  public static final TableColumnType INT2
- INT8
  
  public static final TableColumnType INT8
- INTEGER
  
  public static final TableColumnType INTEGER
- JSON
  
  public static final TableColumnType JSON
- JSONB
  
  public static final TableColumnType JSONB
- LINE
  
  public static final TableColumnType LINE
- LSEG
  
  public static final TableColumnType LSEG
- MACADDR
  
  public static final TableColumnType MACADDR
- MACADDR8
  
  public static final TableColumnType MACADDR8
- MONEY
  
  public static final TableColumnType MONEY
- NUMERIC
  
  public static final TableColumnType NUMERIC
- DECIMAL
  
  public static final TableColumnType DECIMAL
- PATH
  
  public static final TableColumnType PATH
- PG_LSN
  
  public static final TableColumnType PG_LSN
- PG_SNAPSHOT
  
  public static final TableColumnType PG_SNAPSHOT
- POINT
  
  public static final TableColumnType POINT
- POLYGON
  
  public static final TableColumnType POLYGON
- REAL
  
  public static final TableColumnType REAL
- SMALLINT
  
  public static final TableColumnType SMALLINT
- SMALLSERIAL
  
  public static final TableColumnType SMALLSERIAL
- SERIAL
  
  public static final TableColumnType SERIAL
- SERIAL2
  
  public static final TableColumnType SERIAL2
- SERIAL4
  
  public static final TableColumnType SERIAL4
- SERIAL8
  
  public static final TableColumnType SERIAL8
- TEXT
  
  public static final TableColumnType TEXT
- TIME
  
  public static final TableColumnType TIME
- TIME_WITHOUT_TIME_ZONE
  
  public static final TableColumnType TIME_WITHOUT_TIME_ZONE
- TIME_WITH_TIME_ZONE
  
  public static final TableColumnType TIME_WITH_TIME_ZONE
- TIMETZ
  
  public static final TableColumnType TIMETZ
- TIMESTAMP
  
  public static final TableColumnType TIMESTAMP
- TIMESTAMP_WITHOUT_TIME_ZONE
  
  public static final TableColumnType TIMESTAMP_WITHOUT_TIME_ZONE
- TIMESTAMP_WITH_TIME_ZONE
  
  public static final TableColumnType TIMESTAMP_WITH_TIME_ZONE
- TIMESTAMPTZ
  
  public static final TableColumnType TIMESTAMPTZ
- TSQUERY
  
  public static final TableColumnType TSQUERY
- TSVECTOR
  
  public static final TableColumnType TSVECTOR
- TXID_SNAPSHOT
  
  public static final TableColumnType TXID_SNAPSHOT
- UUID
  
  public static final TableColumnType UUID
- XML
  
  public static final TableColumnType XML
Method Details
- values
  
  public static TableColumnType[] values()
  
  Returns an array containing the constants of this enum class, in the order they are declared.
  
  Returns:
  
  an array containing the constants of this enum class, in the order they are declared
- valueOf
  
  public static TableColumnType valueOf(String name)
  
  Returns the enum constant of this class with the specified name. The string must match exactly an identifier used to declare an enum constant in this class. (Extraneous whitespace characters are not permitted.)
  
  Parameters:
  
  name - the name of the enum constant to be returned.
  
  Returns:
  
  the enum constant with the specified name
  
  Throws:
  
  IllegalArgumentException - if this enum class has no constant with the specified name
  
  NullPointerException - if the argument is null
- isLengthSupported
  
  public boolean isLengthSupported()
  
  Indicates if a length or precision may follow this type in a column definition.
- isScaleSupported
  
  public boolean isScaleSupported()
  
  Indicates if a scale may follow the length or precision of this type in a column definition.
- getSqlFragment
  
  public String getSqlFragment()
  
  Returns the type as written in SQL: the lowercase name with spaces for underscores (e.g. double precision).

Enum Class TableColumnType

Nested Class Summary

Nested classes/interfaces inherited from class java.lang.Enum

Enum Constant Summary

Method Summary

Methods inherited from class java.lang.Enum

Methods inherited from class java.lang.Object

Enum Constant Details

BIGINT

BIGSERIAL

BIT

BIT_VARYING

VARBIT

BOOLEAN

BOOL

BOX

BYTEA

CHAR

CHARACTER

CHARACTER_VARYING

VARCHAR

CIDR

CIRCLE

DATE

DOUBLE_PRECISION

FLOAT4

FLOAT8

INET

INT

INT4

INT2

INT8

INTEGER

JSON

JSONB

LINE

LSEG

MACADDR

MACADDR8

MONEY

NUMERIC

DECIMAL

PATH

PG_LSN

PG_SNAPSHOT

POINT

POLYGON

REAL

SMALLINT

SMALLSERIAL

SERIAL

SERIAL2

SERIAL4

SERIAL8

TEXT

TIME

TIME_WITHOUT_TIME_ZONE

TIME_WITH_TIME_ZONE

TIMETZ

TIMESTAMP

TIMESTAMP_WITHOUT_TIME_ZONE

TIMESTAMP_WITH_TIME_ZONE

TIMESTAMPTZ

TSQUERY

TSVECTOR

TXID_SNAPSHOT

UUID

XML

Method Details

values

valueOf

isLengthSupported

isScaleSupported

getSqlFragment