add_column

add_column(table_name, column_name, type, options = {}) Instance Public methods Adds a new column to the named table. See ActiveRecord::ConnectionAdapters::PostgreSQLAdapter::TableDefinition#column for details of the options you can use.

change_column

change_column(table_name, column_name, type, options = {}) Instance Public methods Changes the column of a table.

change_column_default

change_column_default(table_name, column_name, default) Instance Public methods Changes the default value of a table column.

change_column_null

change_column_null(table_name, column_name, null, default = nil) Instance Public methods

client_min_messages

client_min_messages() Instance Public methods Returns the current client message level.

client_min_messages=

client_min_messages=(level) Instance Public methods Set the client message level.

collation

collation() Instance Public methods Returns the current database collation.

columns

columns(table_name) Instance Public methods Returns the list of all column definitions for a table.

create_database

create_database(name, options = {}) Instance Public methods Create a new PostgreSQL database. Options include :owner, :template, :encoding (defaults to utf8), :collation, :ctype, :tablespace, and :connection_limit (note that MySQL uses :charset while PostgreSQL uses :encoding). Example: create_database config[:database], config create_database 'foo_development', encoding: 'unicode'

create_schema

create_schema(schema_name) Instance Public methods Creates a schema for the given schema name.