Table of Contents - pg_saurus-4.3.0 Documentation
Pages
-
README.markdown
- PgSaurus
- More information
- Environment notes
- Schemas
- Create schema
- Create table
- Move table to another schema
- Table and column comments
- Examples
- Foreign keys
- Migration notes - upgrading from Rails 4.2
- Migration notes - upgrading from Rails 4.1
- Partial Indexes
- Examples
- Indexes on Expressions
- Examples
- Indexes with operator classes
- Examples
- Concurrent index creation
- Examples
- Loading/Unloading postgresql extension modules
- Examples
- Views
- Examples
- Roles
- Functions
- Examples
- Triggers
- Examples
- Tools
- Running tests
- Installing contrib packages on Mac OS X:
- TODO
- Credits
- Copyright and License
- Contributing
- pg_saurus_tasks.rake
Classes and Modules
- ActiveRecord
- ActiveRecord::ConnectionAdapters
- ActiveRecord::ConnectionAdapters::PostgreSQL
- ActiveRecord::ConnectionAdapters::PostgreSQL::SchemaStatements
- ActiveRecord::ConnectionAdapters::PostgreSQLColumn
- ActiveRecord::InsufficientPrivilege
- ActiveRecord::SchemaDumper
- ColorizedText
- PgSaurus
- PgSaurus::Config
- PgSaurus::ConnectionAdapters
- PgSaurus::ConnectionAdapters::AbstractAdapter
- PgSaurus::ConnectionAdapters::AbstractAdapter::CommentMethods
- PgSaurus::ConnectionAdapters::AbstractAdapter::FunctionMethods
- PgSaurus::ConnectionAdapters::AbstractAdapter::IndexMethods
- PgSaurus::ConnectionAdapters::AbstractAdapter::SchemaMethods
- PgSaurus::ConnectionAdapters::AbstractAdapter::TriggerMethods
- PgSaurus::ConnectionAdapters::ForeignKeyDefinition
- PgSaurus::ConnectionAdapters::FunctionDefinition
- PgSaurus::ConnectionAdapters::PostgreSQLAdapter
- PgSaurus::ConnectionAdapters::PostgreSQLAdapter::CommentMethods
- PgSaurus::ConnectionAdapters::PostgreSQLAdapter::ExtensionMethods
- PgSaurus::ConnectionAdapters::PostgreSQLAdapter::ForeignKeyMethods
- PgSaurus::ConnectionAdapters::PostgreSQLAdapter::FunctionMethods
- PgSaurus::ConnectionAdapters::PostgreSQLAdapter::IndexMethods
- PgSaurus::ConnectionAdapters::PostgreSQLAdapter::SchemaMethods
- PgSaurus::ConnectionAdapters::PostgreSQLAdapter::TranslateException
- PgSaurus::ConnectionAdapters::PostgreSQLAdapter::TriggerMethods
- PgSaurus::ConnectionAdapters::PostgreSQLAdapter::ViewMethods
- PgSaurus::ConnectionAdapters::Table
- PgSaurus::ConnectionAdapters::Table::CommentMethods
- PgSaurus::ConnectionAdapters::Table::TriggerMethods
- PgSaurus::ConnectionAdapters::TriggerDefinition
- PgSaurus::CreateIndexConcurrently
- PgSaurus::CreateIndexConcurrently::Migration
- PgSaurus::CreateIndexConcurrently::MigrationProxy
- PgSaurus::CreateIndexConcurrently::Migrator
- PgSaurus::Engine
- PgSaurus::Error
- PgSaurus::Generators
- PgSaurus::Generators::InstallGenerator
- PgSaurus::IndexExistsError
- PgSaurus::Migration
- PgSaurus::Migration::CommandRecorder
- PgSaurus::Migration::CommandRecorder::CommentMethods
- PgSaurus::Migration::CommandRecorder::ExtensionMethods
- PgSaurus::Migration::CommandRecorder::FunctionMethods
- PgSaurus::Migration::CommandRecorder::SchemaMethods
- PgSaurus::Migration::CommandRecorder::TriggerMethods
- PgSaurus::Migration::CommandRecorder::ViewMethods
- PgSaurus::Migration::SetRoleMethod
- PgSaurus::Migration::SetRoleMethod::Extension
- PgSaurus::RoleNotSetError
- PgSaurus::SchemaDumper
- PgSaurus::SchemaDumper::CommentMethods
- PgSaurus::SchemaDumper::ExtensionMethods
- PgSaurus::SchemaDumper::ForeignKeyMethods
- PgSaurus::SchemaDumper::FunctionMethods
- PgSaurus::SchemaDumper::SchemaMethods
- PgSaurus::SchemaDumper::TriggerMethods
- PgSaurus::SchemaDumper::ViewMethods
- PgSaurus::Tools
Methods
- ::configure — PgSaurus
- ::keep_default_role — PgSaurus::Migration::SetRoleMethod
- ::keep_default_role? — PgSaurus::Migration::SetRoleMethod
- ::new — PgSaurus::Config
- ::pg_server_version — PgSaurus::Engine
- ::set_role — PgSaurus::Migration::SetRoleMethod
- #add_foreign_key — PgSaurus::ConnectionAdapters::PostgreSQLAdapter::ForeignKeyMethods
- #add_index — PgSaurus::CreateIndexConcurrently::Migration
- #clear_queue — PgSaurus::CreateIndexConcurrently::Migration
- #colorize — ColorizedText
- #comments — PgSaurus::ConnectionAdapters::PostgreSQLAdapter::CommentMethods
- #connection — PgSaurus::Tools
- #create_extension — PgSaurus::ConnectionAdapters::PostgreSQLAdapter::ExtensionMethods
- #create_function — PgSaurus::ConnectionAdapters::AbstractAdapter::FunctionMethods
- #create_function — PgSaurus::ConnectionAdapters::PostgreSQLAdapter::FunctionMethods
- #create_function — PgSaurus::Migration::CommandRecorder::FunctionMethods
- #create_schema_if_not_exists — PgSaurus::ConnectionAdapters::PostgreSQLAdapter::SchemaMethods
- #create_schema_if_not_exists — PgSaurus::Tools
- #create_table — PgSaurus::ConnectionAdapters::AbstractAdapter::SchemaMethods
- #create_trigger — PgSaurus::ConnectionAdapters::AbstractAdapter::TriggerMethods
- #create_trigger — PgSaurus::ConnectionAdapters::PostgreSQLAdapter::TriggerMethods
- #create_trigger — PgSaurus::ConnectionAdapters::Table::TriggerMethods
- #create_view — PgSaurus::ConnectionAdapters::PostgreSQLAdapter::ViewMethods
- #create_view — PgSaurus::Migration::CommandRecorder::ViewMethods
- #create_view — PgSaurus::Tools
- #current_schema_search_path — PgSaurus::ConnectionAdapters::PostgreSQLAdapter::SchemaMethods
- #ddl_transaction — PgSaurus::CreateIndexConcurrently::Migrator
- #drop_extension — PgSaurus::ConnectionAdapters::PostgreSQLAdapter::ExtensionMethods
- #drop_function — PgSaurus::ConnectionAdapters::AbstractAdapter::FunctionMethods
- #drop_function — PgSaurus::ConnectionAdapters::PostgreSQLAdapter::FunctionMethods
- #drop_function — PgSaurus::Migration::CommandRecorder::FunctionMethods
- #drop_schema_if_exists — PgSaurus::ConnectionAdapters::PostgreSQLAdapter::SchemaMethods
- #drop_schema_if_exists — PgSaurus::Tools
- #drop_table — PgSaurus::ConnectionAdapters::AbstractAdapter::SchemaMethods
- #drop_table — PgSaurus::ConnectionAdapters::PostgreSQLAdapter::ForeignKeyMethods
- #drop_table — PgSaurus::ConnectionAdapters::PostgreSQLAdapter::SchemaMethods
- #drop_view — PgSaurus::ConnectionAdapters::PostgreSQLAdapter::ViewMethods
- #drop_view — PgSaurus::Migration::CommandRecorder::ViewMethods
- #drop_view — PgSaurus::Tools
- #dump_comments — PgSaurus::SchemaDumper::CommentMethods
- #dump_extensions — PgSaurus::SchemaDumper::ExtensionMethods
- #dump_functions — PgSaurus::SchemaDumper::FunctionMethods
- #dump_triggers — PgSaurus::SchemaDumper::TriggerMethods
- #enable_extension — PgSaurus::ConnectionAdapters::PostgreSQLAdapter::ExtensionMethods
- #enque — PgSaurus::CreateIndexConcurrently::Migration
- #exec_migration — PgSaurus::Migration::SetRoleMethod::Extension
- #foreign_key_column_for — PgSaurus::ConnectionAdapters::PostgreSQLAdapter::ForeignKeyMethods
- #foreign_keys — PgSaurus::ConnectionAdapters::PostgreSQLAdapter::ForeignKeyMethods
- #foreign_keys — PgSaurus::SchemaDumper::ForeignKeyMethods
- #format_comment — PgSaurus::SchemaDumper::CommentMethods
- #from_schema — PgSaurus::ConnectionAdapters::PostgreSQLAdapter
- #full_function_name — PgSaurus::ConnectionAdapters::PostgreSQLAdapter::FunctionMethods
- #functions — PgSaurus::ConnectionAdapters::AbstractAdapter::FunctionMethods
- #functions — PgSaurus::ConnectionAdapters::PostgreSQLAdapter::FunctionMethods
- #header — PgSaurus::SchemaDumper::ExtensionMethods
- #header — PgSaurus::SchemaDumper::SchemaMethods
- #in_schema — PgSaurus::ConnectionAdapters::PostgreSQLAdapter::SchemaMethods
- #index_comments — PgSaurus::ConnectionAdapters::PostgreSQLAdapter::CommentMethods
- #invert_create_function — PgSaurus::Migration::CommandRecorder::FunctionMethods
- #invert_create_view — PgSaurus::Migration::CommandRecorder::ViewMethods
- #is_constraint? — PgSaurus::ConnectionAdapters::PostgreSQLAdapter::TriggerMethods
- #move_table_to_schema — PgSaurus::ConnectionAdapters::PostgreSQLAdapter::SchemaMethods
- #move_table_to_schema — PgSaurus::Tools
- #parse_condition — PgSaurus::ConnectionAdapters::PostgreSQLAdapter::TriggerMethods
- #parse_event — PgSaurus::ConnectionAdapters::PostgreSQLAdapter::TriggerMethods
- #parse_function_definition — PgSaurus::ConnectionAdapters::PostgreSQLAdapter::FunctionMethods
- #parse_function_language — PgSaurus::ConnectionAdapters::PostgreSQLAdapter::FunctionMethods
- #parse_function_name — PgSaurus::ConnectionAdapters::PostgreSQLAdapter::FunctionMethods
- #parse_function_volatility — PgSaurus::ConnectionAdapters::PostgreSQLAdapter::FunctionMethods
- #parse_proc_name — PgSaurus::ConnectionAdapters::PostgreSQLAdapter::TriggerMethods
- #pg_extensions — PgSaurus::ConnectionAdapters::PostgreSQLAdapter::ExtensionMethods
- #process_postponed_queries — PgSaurus::CreateIndexConcurrently::Migration
- #quote_table_or_view — PgSaurus::ConnectionAdapters::PostgreSQLAdapter::TriggerMethods
- #remove_column_comment — PgSaurus::ConnectionAdapters::AbstractAdapter::CommentMethods
- #remove_column_comment — PgSaurus::ConnectionAdapters::PostgreSQLAdapter::CommentMethods
- #remove_column_comment — PgSaurus::ConnectionAdapters::Table::CommentMethods
- #remove_column_comments — PgSaurus::ConnectionAdapters::AbstractAdapter::CommentMethods
- #remove_column_comments — PgSaurus::ConnectionAdapters::PostgreSQLAdapter::CommentMethods
- #remove_column_comments — PgSaurus::ConnectionAdapters::Table::CommentMethods
- #remove_foreign_key — PgSaurus::ConnectionAdapters::PostgreSQLAdapter::ForeignKeyMethods
- #remove_index_comment — PgSaurus::ConnectionAdapters::AbstractAdapter::CommentMethods
- #remove_index_comment — PgSaurus::ConnectionAdapters::PostgreSQLAdapter::CommentMethods
- #remove_table_comment — PgSaurus::ConnectionAdapters::AbstractAdapter::CommentMethods
- #remove_table_comment — PgSaurus::ConnectionAdapters::PostgreSQLAdapter::CommentMethods
- #remove_table_comment — PgSaurus::ConnectionAdapters::Table::CommentMethods
- #remove_trigger — PgSaurus::ConnectionAdapters::AbstractAdapter::TriggerMethods
- #remove_trigger — PgSaurus::ConnectionAdapters::PostgreSQLAdapter::TriggerMethods
- #remove_trigger — PgSaurus::ConnectionAdapters::Table::TriggerMethods
- #rename_table — PgSaurus::ConnectionAdapters::PostgreSQLAdapter::SchemaMethods
- #role — PgSaurus::Migration::SetRoleMethod
- #schema — PgSaurus::SchemaDumper::SchemaMethods
- #schemas — PgSaurus::SchemaDumper::SchemaMethods
- #schemas — PgSaurus::Tools
- #set_column_comment — PgSaurus::ConnectionAdapters::AbstractAdapter::CommentMethods
- #set_column_comment — PgSaurus::ConnectionAdapters::PostgreSQLAdapter::CommentMethods
- #set_column_comment — PgSaurus::ConnectionAdapters::Table::CommentMethods
- #set_column_comments — PgSaurus::ConnectionAdapters::AbstractAdapter::CommentMethods
- #set_column_comments — PgSaurus::ConnectionAdapters::PostgreSQLAdapter::CommentMethods
- #set_column_comments — PgSaurus::ConnectionAdapters::Table::CommentMethods
- #set_index_comment — PgSaurus::ConnectionAdapters::AbstractAdapter::CommentMethods
- #set_index_comment — PgSaurus::ConnectionAdapters::PostgreSQLAdapter::CommentMethods
- #set_table_comment — PgSaurus::ConnectionAdapters::AbstractAdapter::CommentMethods
- #set_table_comment — PgSaurus::ConnectionAdapters::PostgreSQLAdapter::CommentMethods
- #set_table_comment — PgSaurus::ConnectionAdapters::Table::CommentMethods
- #supports_comments? — PgSaurus::ConnectionAdapters::AbstractAdapter::CommentMethods
- #supports_comments? — PgSaurus::ConnectionAdapters::PostgreSQLAdapter::CommentMethods
- #supports_extensions? — PgSaurus::ConnectionAdapters::PostgreSQLAdapter::ExtensionMethods
- #supports_functions? — PgSaurus::ConnectionAdapters::AbstractAdapter::FunctionMethods
- #supports_functions? — PgSaurus::ConnectionAdapters::PostgreSQLAdapter::FunctionMethods
- #supports_partial_index? — PgSaurus::ConnectionAdapters::AbstractAdapter::IndexMethods
- #supports_partial_index? — PgSaurus::ConnectionAdapters::PostgreSQLAdapter::IndexMethods
- #supports_triggers? — PgSaurus::ConnectionAdapters::AbstractAdapter::TriggerMethods
- #supports_triggers? — PgSaurus::ConnectionAdapters::PostgreSQLAdapter::TriggerMethods
- #tables — PgSaurus::ConnectionAdapters::PostgreSQLAdapter::SchemaMethods
- #tables — PgSaurus::SchemaDumper::CommentMethods
- #tables — PgSaurus::SchemaDumper::FunctionMethods
- #tables — PgSaurus::SchemaDumper::TriggerMethods
- #tables — PgSaurus::SchemaDumper::ViewMethods
- #to_schema_and_table — PgSaurus::Tools
- #translate_exception — PgSaurus::ConnectionAdapters::PostgreSQLAdapter::TranslateException
- #trigger_name — PgSaurus::ConnectionAdapters::PostgreSQLAdapter::TriggerMethods
- #triggers — PgSaurus::ConnectionAdapters::AbstractAdapter::TriggerMethods
- #triggers — PgSaurus::ConnectionAdapters::PostgreSQLAdapter::TriggerMethods
- #views — PgSaurus::SchemaDumper::ViewMethods
- #views — PgSaurus::Tools
- #write_view_definition — PgSaurus::SchemaDumper::ViewMethods