PostgresqlDatabaseAdapter
Related Doc:
package migration
This value is true if the database implicitly adds an index on the column that has a foreign key constraint added to it.
This value is true if the database implicitly adds an index on the column that has a foreign key constraint added to it.
The following SQL can be used to test the database. The last statement will fail with a message that there already is an index on the column.
CREATE TABLE parent (pk INT PRIMARY KEY); CREATE TABLE child (pk INT PRIMARY KEY, pk_parent INT NOT NULL); ALTER TABLE child ADD CONSTRAINT idx_child_pk_parent FOREIGN KEY (pk_parent) REFERENCES parent (pk); CREATE INDEX idx_child_pk_parent ON child (pk_parent);
Different databases require different SQL to alter a column's definition.
Different databases require different SQL to alter a column's definition. Uses the schemaNameOpt defined in the adapter.
the name of the table with the column
the name of the column
the type the column is being altered to
a possibly empty array of column options to customize the column
the SQL to alter the column
Different databases require different SQL to alter a column's definition.
Different databases require different SQL to alter a column's definition.
the optional schema name to qualify the table name
the name of the table with the column
the name of the column
the type the column is being altered to
a possibly empty array of column options to customize the column
the SQL to alter the column
The SQL keyword(s) or "phrase" used to drop a foreign key constraint.
The SQL keyword(s) or "phrase" used to drop a foreign key constraint. For example, Derby, Oracle and PostgreSQL use
ALTER TABLE child DROP CONSTRAINT idx_child_pk_parent; ^^^^^^^^^^
while MySQL uses
ALTER TABLE child DROP FOREIGN KEY idx_child_pk_parent; ^^^^^^^^^^
Concrete subclasses must define this method that returns a newly constructed, but uninitialized, concrete ColumnDefinition subclass for the given SQL data type and optional CharacterSet.
Concrete subclasses must define this method that returns a newly constructed, but uninitialized, concrete ColumnDefinition subclass for the given SQL data type and optional CharacterSet.
the column's data type
an optional CharacterSet
a newly constructed but uninitialized ColumnDefinition for the columnType
对某一列增加注释
对表添加注释
Given a check constraint, create a name for it, using a Name() if it is provided in the options.
Given a check constraint, create a name for it, using a Name() if it is provided in the options.
the table and columns the check constraint is on
a varargs list of CheckOptions
a two-tuple with the calculated name or the overridden name from a Name and the remaining options
Grant one or more privileges to a schema.
Grant one or more privileges to a schema.
one or more objects to grant the new privileges to
one or more SchemaPrivilege objects describing the types of privileges to grant
the SQL to grant privileges
Grant one or more privileges to a schema.
Grant one or more privileges to a schema.
the name of the schema to grant privileges on
one or more objects to grant the new privileges to
one or more SchemaPrivilege objects describing the types of privileges to grant
the SQL to grant privileges
Different databases have different limitations on the GRANT statement.
Different databases have different limitations on the GRANT statement. Uses the schemaNameOpt defined in the adapter.
the name of the table with the index
one or more objects to grant the new privileges to
one or more GrantPrivilegeType objects describing the types of privileges to grant
the SQL to grant privileges
Different databases have different limitations on the GRANT statement.
Different databases have different limitations on the GRANT statement.
the optional schema name to qualify the table name
the name of the table with the index
one or more objects to grant the new privileges to
one or more GrantPrivilegeType objects describing the types of privileges to grant
the SQL to grant privileges
Different databases require different SQL to lock a table.
Different databases require different SQL to lock a table.
the name of the table to lock
the SQL to lock the table
Different databases require different SQL to lock a table.
Different databases require different SQL to lock a table.
the optional schema name to qualify the table name
the name of the table to lock
the SQL to lock the table
Given a table name, column name and column data type, return a newly constructed and fully initialized ColumnDefinition.
Given a table name, column name and column data type, return a newly constructed and fully initialized ColumnDefinition. The class of the returned ColumnDefinition only depends upon the input column data type.
the name of the table the column is in
the column's name
the data type of the column
a list of column options customizing the column
a new ColumnDefinition
Return the SQL text in a foreign key relationship for an optional ON DELETE clause.
Return the SQL text in a foreign key relationship for an optional ON DELETE clause.
an Option[OnDelete]
the SQL text to append to the SQL to create a foreign key relationship
Return the SQL text in a foreign key relationship for an optional ON UPDATE clause.
Return the SQL text in a foreign key relationship for an optional ON UPDATE clause.
an Option[OnUpdate]
the SQL text to append to the SQL to create a foreign key relationship
The character that is used to quote identifiers.
The character that is used to quote identifiers.
Quote a column name.
Quote a column name.
the name of the column to quote
a properly quoted column name
Quote an index name.
Quote an index name.
an optional schema name
the name of the index to quote
a properly quoted index name
Quote a schema name.
Quote a schema name.
the name of the schema to quote
a properly quoted schema name
Quote a table name.
Quote a table name. If the database adapter was provided with a default schema name, then the quoted table name is prepended with the quoted schema name along with a '.'.
the name of the table to quote
the table name properly quoted for the database, prepended with the quoted schema name and a '.' if the database adapter was provided with a default schema name
Quote a table name, prepending the quoted schema name to the quoted table name along with a '.' if a schema name is provided.
Quote a table name, prepending the quoted schema name to the quoted table name along with a '.' if a schema name is provided.
an optional schema name
the name of the table to quote
the table name properly quoted for the database, prepended with the quoted schema name and a '.' if a schema name is provided
Different databases require different SQL to drop a column.
Different databases require different SQL to drop a column. Uses the schemaNameOpt defined in the adapter.
the name of the table with the column
the name of the column
the SQL to drop the column
Different databases require different SQL to drop a column.
Different databases require different SQL to drop a column.
the optional schema name to qualify the table name
the name of the table with the column
the name of the column
the SQL to drop the column
Different databases require different SQL to drop an index.
Different databases require different SQL to drop an index. Uses the schemaNameOpt defined in the adapter.
the name of the table with the index
the name of the index
the SQL to drop the index
Different databases require different SQL to drop an index.
Different databases require different SQL to drop an index.
the optional schema name to qualify the table name
the name of the table with the index
the name of the index
the SQL to drop the index
Revoke one or more privileges from a schema.
Revoke one or more privileges from a schema.
one or more objects to revoke the privileges from
one or more SchemaPrivilege objects describing the types of privileges to revoke
the SQL to revoke privileges
Revoke one or more privileges from a schema.
Revoke one or more privileges from a schema.
the name of the schema to revoke privileges from
one or more objects to revoke the privileges from
one or more SchemaPrivilege objects describing the types of privileges to revoke
the SQL to revoke privileges
Different databases have different limitations on the REVOKE statement.
Different databases have different limitations on the REVOKE statement. Uses the schemaNameOpt defined in the adapter.
the name of the table with the index
one or more objects to revoke the privileges from
one or more GrantPrivilegeType objects describing the types of privileges to revoke
the SQL to revoke privileges
Different databases have different limitations on the REVOKE statement.
Different databases have different limitations on the REVOKE statement.
the optional schema name to qualify the table name
the name of the table with the index
one or more objects to revoke the privileges from
one or more GrantPrivilegeType objects describing the types of privileges to revoke
the SQL to revoke privileges
If the database supports table and column check constraints.
If the database supports table and column check constraints.
To properly quote table names the database adapter needs to know how the database treats unquoted names.
To properly quote table names the database adapter needs to know how the database treats unquoted names.
A factory for creating User instances from a bare user name.
A factory for creating User instances from a bare user name.
The vendor of the database.
The vendor of the database.