rename_index

rename_index(table_name, old_name, new_name) Instance Public methods

rename_table

rename_table(table_name, new_name) Instance Public methods Renames a table. Also renames a table's primary key sequence if the sequence name matches the Active Record default. Example: rename_table('octopuses', 'octopi')

schema_exists?

schema_exists?(name) Instance Public methods Returns true if schema exists.

schema_names

schema_names() Instance Public methods Returns an array of schema names.

schema_search_path

schema_search_path() Instance Public methods Returns the active schema search path.

schema_search_path=

schema_search_path=(schema_csv) Instance Public methods Sets the schema search path to a string of comma-separated schema names. Names beginning with $ have to be quoted (e.g. $user => '$user'). See: www.postgresql.org/docs/current/static/ddl-schemas.html This should be not be called manually but set in database.yml.

serial_sequence

serial_sequence(table, column) Instance Public methods

table_exists?

table_exists?(name) Instance Public methods Returns true if table exists. If the schema is not specified as part of name then it will only find tables within the current schema search path (regardless of permissions to access tables in other schemas)

tables

tables(name = nil) Instance Public methods Returns the list of all tables in the schema search path or a specified schema.

type_to_sql

type_to_sql(type, limit = nil, precision = nil, scale = nil) Instance Public methods Maps logical Rails types to PostgreSQL-specific data types.