Package org.pgcodekeeper.core.loader

Class JdbcQueries

java.lang.Object

org.pgcodekeeper.core.loader.JdbcQueries

public class JdbcQueries
extends Object

Utility class containing pre-built SQL queries for JDBC database operations. Provides queries for PostgreSQL metadata extraction, version checking, privilege validation, and system object enumeration.

Field Summary

Fields

Modifier and Type	Field	Description
static final String	QUERY_CHECK_GREENPLUM
static final String	QUERY_CHECK_LAST_SYS_OID
static final String	QUERY_CHECK_MS_VERSION
static final String	QUERY_CHECK_PG_VERSION
static final String	QUERY_CHECK_TIMESTAMPS
static final String	QUERY_CHECK_USER_PRIVILEGES
static final String	QUERY_SCHEMAS_ACCESS
static final String	QUERY_SEQUENCES_ACCESS
static final String	QUERY_SEQUENCES_DATA
static final String	QUERY_SYSTEM_CASTS
static final String	QUERY_SYSTEM_FUNCTIONS
static final String	QUERY_SYSTEM_OPERATORS
static final String	QUERY_SYSTEM_RELATIONS
static final String	QUERY_TOTAL_OBJECTS_COUNT
static final String	QUERY_TYPES_FOR_CACHE_ALL

Method Summary

Methods inherited from class java.lang.Object

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

Field Details

QUERY_TOTAL_OBJECTS_COUNT

public static final String QUERY_TOTAL_OBJECTS_COUNT

QUERY_TYPES_FOR_CACHE_ALL

public static final String QUERY_TYPES_FOR_CACHE_ALL

QUERY_CHECK_TIMESTAMPS

public static final String QUERY_CHECK_TIMESTAMPS

QUERY_CHECK_LAST_SYS_OID

public static final String QUERY_CHECK_LAST_SYS_OID

QUERY_CHECK_USER_PRIVILEGES

public static final String QUERY_CHECK_USER_PRIVILEGES

QUERY_CHECK_PG_VERSION

public static final String QUERY_CHECK_PG_VERSION

QUERY_CHECK_GREENPLUM

public static final String QUERY_CHECK_GREENPLUM

QUERY_CHECK_MS_VERSION

public static final String QUERY_CHECK_MS_VERSION

QUERY_SCHEMAS_ACCESS

public static final String QUERY_SCHEMAS_ACCESS

QUERY_SEQUENCES_ACCESS

public static final String QUERY_SEQUENCES_ACCESS

QUERY_SEQUENCES_DATA

public static final String QUERY_SEQUENCES_DATA

QUERY_SYSTEM_FUNCTIONS

public static final String QUERY_SYSTEM_FUNCTIONS

QUERY_SYSTEM_RELATIONS

public static final String QUERY_SYSTEM_RELATIONS

QUERY_SYSTEM_OPERATORS

public static final String QUERY_SYSTEM_OPERATORS

QUERY_SYSTEM_CASTS

public static final String QUERY_SYSTEM_CASTS