com.northconcepts.datapipeline.sql.postgresql (Data Pipeline JavaDoc)

package com.northconcepts.datapipeline.sql.postgresql

Generate SQL code for the PostgreSQL database.

Class

Description

ConflictAction

The ON CONFLICT action of an Upsert: update the inserted columns (DO UPDATE SET) or DO NOTHING.

CreateForeignKey

Generates an ALTER TABLE...ADD CONSTRAINT statement to add a foreign key constraint in PostgreSQL.

CreateIndex

Generates a CREATE INDEX statement for PostgreSQL.

CreatePostgreSqlDdlFromSchemaDef

Generates PostgreSQL DDL from SchemaDef

CreateTable

Generates a CREATE TABLE statement for PostgreSQL.

CreateTableColumn

Generates a column definition for a CREATE TABLE statement for PostgreSQL.

DropTable

Generates a DROP TABLE statement for PostgreSQL.

DropTableConstraint

Generates a ALTER TABLE...DROP CONSTRAINT statement for PostgreSQL.

ForeignKeyAction

Referential action written in the ON DELETE and ON UPDATE clauses of a CreateForeignKey.

Insert

Generates an INSERT INTO statement for PostgreSQL.

InsertRow

A row of values in an Insert or Upsert; each value is written as-is, so it must already be an SQL literal.

InsertValue

A column name and value pair in an InsertRow.

PostgreSqlInsertWriter

Generates PostgreSQL insert statement from records.

PostgreSqlUpsertWriter

Generates PostgreSQL upsert statement from records.

PostgresSqlPart

Base class for the PostgreSQL statement builders; identifiers are quoted with double quotes.

TableColumnType

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

Upsert

Generates an upsert statement for PostgreSQL.

Package com.northconcepts.datapipeline.sql.postgresql