Package com.exasol.dbbuilder.dialects.postgres

Class PostgreSqlImmediateDatabaseObjectWriter

java.lang.Object

com.exasol.dbbuilder.dialects.AbstractImmediateDatabaseObjectWriter

com.exasol.dbbuilder.dialects.postgres.PostgreSqlImmediateDatabaseObjectWriter

All Implemented Interfaces:

DatabaseObjectWriter

public class PostgreSqlImmediateDatabaseObjectWriter
extends AbstractImmediateDatabaseObjectWriter

PostgreSQL DatabaseObjectWriter.

Field Summary

Fields inherited from class com.exasol.dbbuilder.dialects.AbstractImmediateDatabaseObjectWriter

connection

Constructor Summary

Constructors

Constructor	Description
PostgreSqlImmediateDatabaseObjectWriter(Connection connectionToPostgres)	Create a new instance of PostgreSqlImmediateDatabaseObjectWriter.

Method Summary

Modifier and Type	Method	Description
void	drop(Schema schema)	Drop a schema.
protected String	getQuotedColumnName(String columnName)	Get a quoted column name.
void	write(User user)	Create a user in the database.
void	write(User user, GlobalPrivilege... privileges)	Grant system privileges to a user.

Methods inherited from class com.exasol.dbbuilder.dialects.AbstractImmediateDatabaseObjectWriter

createCommaSeparatedObjectPrivilegeList, createCommaSeparatedSystemPrivilegeList, drop, drop, executeSqlFile, truncate, write, write, write, write, writeToObject

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

PostgreSqlImmediateDatabaseObjectWriter

public PostgreSqlImmediateDatabaseObjectWriter(Connection connectionToPostgres)

Create a new instance of PostgreSqlImmediateDatabaseObjectWriter.

Parameters:

connectionToPostgres - connection to the PostgreSQL database.

Method Detail

getQuotedColumnName

protected String getQuotedColumnName(String columnName)

Description copied from class: AbstractImmediateDatabaseObjectWriter

Get a quoted column name.

Specified by:

getQuotedColumnName in class AbstractImmediateDatabaseObjectWriter

Parameters:

columnName - name of a column

Returns:

quoted column name

write

public void write(User user)

Description copied from interface: DatabaseObjectWriter

Create a user in the database.

Parameters:

user - to be created

write

public void write(User user,
                  GlobalPrivilege... privileges)

Description copied from interface: DatabaseObjectWriter

Grant system privileges to a user.

Parameters:

user - user who gets the privileges

privileges - privileges to be assigned

drop

public void drop(Schema schema)

Description copied from interface: DatabaseObjectWriter

Drop a schema.

Parameters:

schema - to drop