Index

Symbols

--config <config-file> command line option --exclude-schema <schema> dbtoyaml command line option --exclude-table <table> dbtoyaml command line option --host <host> command line option --output <file> command line option --port <port> command line option --quote-reserved yamltodb command line option --repository <path> command line option --schema <schema> dbtoyaml command line option yamltodb command line option --single-transaction yamltodb command line option --table <table> dbtoyaml command line option --user <username> command line option --version command line option -1 yamltodb command line option -c <config-file> command line option

-H <host> command line option -h, --help command line option -m, --multiple-files dbtoyaml command line option yamltodb command line option -n <schema> dbtoyaml command line option yamltodb command line option -N <schema> dbtoyaml command line option -o <file> command line option -O, --no-owner dbtoyaml command line option -p <port> command line option -r <path> command line option -t <table> dbtoyaml command line option -T <table> dbtoyaml command line option -U <username> command line option -u, --update yamltodb command line option -W, --password command line option -x, --no-privileges dbtoyaml command line option

A

add() (pyrseas.dbobject.column.Column method) (pyrseas.dbobject.constraint.CheckConstraint method) (pyrseas.dbobject.constraint.Constraint method) (pyrseas.dbobject.constraint.ForeignKey method) add_owner() (pyrseas.dbobject.table.Sequence method) add_privs() (pyrseas.dbobject.column.Column method) Aggregate (class in pyrseas.dbobject.function) alter_owner() (pyrseas.dbobject.DbObject method) apply() (pyrseas.augment.audit.CfgAuditColumn method) (pyrseas.augment.column.CfgColumn method) (pyrseas.augment.function.CfgFunction method) (pyrseas.augment.schema.AugSchema method) (pyrseas.augment.table.AugTable method) (pyrseas.augment.trigger.CfgTrigger method) (pyrseas.augmentdb.AugmentDatabase method)

AugClassDict (class in pyrseas.augment.table) AugDbClass (class in pyrseas.augment.table) AugmentDatabase (class in pyrseas.augmentdb) AugSchema (class in pyrseas.augment.schema) AugSchemaDict (class in pyrseas.augment.schema) AugTable (class in pyrseas.augment.table)

B

BaseType (class in pyrseas.dbobject.dbtype)

C

Cast (class in pyrseas.dbobject.cast) CastDict (class in pyrseas.dbobject.cast) CfgAuditColumn (class in pyrseas.augment.audit) CfgAuditColumnDict (class in pyrseas.augment.audit) CfgColumn (class in pyrseas.augment.column) CfgColumnDict (class in pyrseas.augment.column) CfgFunction (class in pyrseas.augment.function) CfgFunctionDict (class in pyrseas.augment.function) CfgFunctionSource (class in pyrseas.augment.function) CfgFunctionSourceDict (class in pyrseas.augment.function) CfgFunctionTemplate (class in pyrseas.augment.function) CfgTrigger (class in pyrseas.augment.trigger) CfgTriggerDict (class in pyrseas.augment.trigger) CheckConstraint (class in pyrseas.dbobject.constraint) ClassDict (class in pyrseas.dbobject.table) close() (pyrseas.lib.dbconn.DbConnection method)

cls (pyrseas.dbobject.DbObjectDict attribute) Collation (class in pyrseas.dbobject.collation) CollationDict (class in pyrseas.dbobject.collation) Column (class in pyrseas.dbobject.column) column_names() (pyrseas.dbobject.table.Table method) ColumnDict (class in pyrseas.dbobject.column) command line option --config <config-file> --host <host> --output <file> --port <port> --repository <path> --user <username> --version -H <host> -U <username> -W, --password -c <config-file> -h, --help -o <file> -p <port> -r <path> comment() (pyrseas.dbobject.column.Column method) (pyrseas.dbobject.DbObject method) (pyrseas.dbobject.constraint.Constraint method) commit() (pyrseas.lib.dbconn.DbConnection method) Composite (class in pyrseas.dbobject.dbtype) connect() (pyrseas.lib.dbconn.DbConnection method) Constraint (class in pyrseas.dbobject.constraint) ConstraintDict (class in pyrseas.dbobject.constraint) Conversion (class in pyrseas.dbobject.conversion) ConversionDict (class in pyrseas.dbobject.conversion) create() (pyrseas.dbobject.cast.Cast method) (pyrseas.dbobject.collation.Collation method) (pyrseas.dbobject.conversion.Conversion method) (pyrseas.dbobject.dbtype.BaseType method) (pyrseas.dbobject.dbtype.Composite method) (pyrseas.dbobject.dbtype.Domain method) (pyrseas.dbobject.dbtype.Enum method) (pyrseas.dbobject.eventtrig.EventTrigger method) (pyrseas.dbobject.extension.Extension method) (pyrseas.dbobject.foreign.ForeignDataWrapper method) (pyrseas.dbobject.foreign.ForeignServer method) (pyrseas.dbobject.foreign.ForeignTable method) (pyrseas.dbobject.foreign.UserMapping method) (pyrseas.dbobject.function.Aggregate method) (pyrseas.dbobject.function.Function method) (pyrseas.dbobject.index.Index method) (pyrseas.dbobject.language.Language method) (pyrseas.dbobject.operator.Operator method) (pyrseas.dbobject.operclass.OperatorClass method) (pyrseas.dbobject.operfamily.OperatorFamily method) (pyrseas.dbobject.rule.Rule method) (pyrseas.dbobject.schema.Schema method) (pyrseas.dbobject.table.Sequence method) (pyrseas.dbobject.table.Table method) (pyrseas.dbobject.table.View method) (pyrseas.dbobject.textsearch.TSConfiguration method) (pyrseas.dbobject.textsearch.TSDictionary method) (pyrseas.dbobject.textsearch.TSParser method) (pyrseas.dbobject.textsearch.TSTemplate method) (pyrseas.dbobject.trigger.Trigger method)

D

data_export() (pyrseas.dbobject.table.Table method) data_import() (pyrseas.dbobject.schema.Schema method) (pyrseas.dbobject.schema.SchemaDict method) (pyrseas.dbobject.table.Table method) Database (class in pyrseas.database) DbClass (class in pyrseas.dbobject.table) DbConnection (class in pyrseas.lib.dbconn) DbObject (class in pyrseas.dbobject) DbObjectDict (class in pyrseas.dbobject) DbObjectWithOptions (class in pyrseas.dbobject.foreign) DbSchemaObject (class in pyrseas.dbobject)

dbtoyaml command line option --exclude-schema <schema> --exclude-table <table> --schema <schema> --table <table> -N <schema> -O, --no-owner -T <table> -m, --multiple-files -n <schema> -t <table> -x, --no-privileges DbType (class in pyrseas.dbobject.dbtype) diff_description() (pyrseas.dbobject.DbObject method) diff_map() (pyrseas.database.Database method) (pyrseas.dbobject.DbObject method) (pyrseas.dbobject.cast.Cast method) (pyrseas.dbobject.cast.CastDict method) (pyrseas.dbobject.collation.CollationDict method) (pyrseas.dbobject.column.Column method) (pyrseas.dbobject.column.ColumnDict method) (pyrseas.dbobject.constraint.CheckConstraint method) (pyrseas.dbobject.constraint.ConstraintDict method) (pyrseas.dbobject.constraint.ForeignKey method) (pyrseas.dbobject.constraint.PrimaryKey method) (pyrseas.dbobject.constraint.UniqueConstraint method) (pyrseas.dbobject.conversion.ConversionDict method) (pyrseas.dbobject.dbtype.Composite method) (pyrseas.dbobject.dbtype.TypeDict method) (pyrseas.dbobject.eventtrig.EventTriggerDict method) (pyrseas.dbobject.extension.ExtensionDict method) (pyrseas.dbobject.foreign.DbObjectWithOptions method) (pyrseas.dbobject.foreign.ForeignDataWrapper method) (pyrseas.dbobject.foreign.ForeignDataWrapperDict method) (pyrseas.dbobject.foreign.ForeignServer method) (pyrseas.dbobject.foreign.ForeignServerDict method) (pyrseas.dbobject.foreign.ForeignTable method) (pyrseas.dbobject.foreign.ForeignTableDict method) (pyrseas.dbobject.foreign.UserMappingDict method) (pyrseas.dbobject.function.Function method) (pyrseas.dbobject.function.ProcDict method) (pyrseas.dbobject.index.Index method) (pyrseas.dbobject.index.IndexDict method) (pyrseas.dbobject.language.LanguageDict method) (pyrseas.dbobject.operator.OperatorDict method) (pyrseas.dbobject.operclass.OperatorClassDict method) (pyrseas.dbobject.operfamily.OperatorFamilyDict method) (pyrseas.dbobject.rule.RuleDict method) (pyrseas.dbobject.schema.SchemaDict method) (pyrseas.dbobject.table.ClassDict method) (pyrseas.dbobject.table.MaterializedView method) (pyrseas.dbobject.table.Sequence method) (pyrseas.dbobject.table.Table method) (pyrseas.dbobject.table.View method) (pyrseas.dbobject.textsearch.TSConfigurationDict method) (pyrseas.dbobject.textsearch.TSDictionaryDict method) (pyrseas.dbobject.textsearch.TSParserDict method) (pyrseas.dbobject.textsearch.TSTemplateDict method) (pyrseas.dbobject.trigger.TriggerDict method) diff_options() (pyrseas.dbobject.foreign.DbObjectWithOptions method) (pyrseas.dbobject.table.Table method) diff_privileges() (pyrseas.dbobject.column.Column method) (pyrseas.dbobject.DbObject method) Domain (class in pyrseas.dbobject.dbtype) drop() (pyrseas.dbobject.column.Column method) (pyrseas.dbobject.DbObject method) (pyrseas.dbobject.DbSchemaObject method) (pyrseas.dbobject.constraint.Constraint method) (pyrseas.dbobject.dbtype.BaseType method) (pyrseas.dbobject.foreign.ForeignTable method) (pyrseas.dbobject.table.Table method)

E

Enum (class in pyrseas.dbobject.dbtype) EventTrigger (class in pyrseas.dbobject.eventtrig) EventTriggerDict (class in pyrseas.dbobject.eventtrig) execute() (pyrseas.lib.dbconn.DbConnection method) Extension (class in pyrseas.dbobject.extension)

ExtensionDict (class in pyrseas.dbobject.extension) extern_dir() (pyrseas.dbobject.schema.Schema method) extern_filename() (pyrseas.dbobject.DbObject method) extern_key() (pyrseas.dbobject.cast.Cast method) (pyrseas.dbobject.DbObject method) (pyrseas.dbobject.foreign.UserMapping method) (pyrseas.dbobject.function.Proc method) (pyrseas.dbobject.operator.Operator method) (pyrseas.dbobject.operclass.OperatorClass method) (pyrseas.dbobject.operfamily.OperatorFamily method)

F

fetch() (pyrseas.dbobject.DbObjectDict method) fetchall() (pyrseas.lib.dbconn.DbConnection method) fetchone() (pyrseas.lib.dbconn.DbConnection method) ForeignDataWrapper (class in pyrseas.dbobject.foreign) ForeignDataWrapperDict (class in pyrseas.dbobject.foreign) ForeignKey (class in pyrseas.dbobject.constraint) ForeignServer (class in pyrseas.dbobject.foreign)

ForeignServerDict (class in pyrseas.dbobject.foreign) ForeignTable (class in pyrseas.dbobject.foreign) ForeignTableDict (class in pyrseas.dbobject.foreign) from_augmap() (pyrseas.augmentdb.AugmentDatabase method) from_catalog() (pyrseas.database.Database method) from_map() (pyrseas.augment.audit.CfgAuditColumnDict method) (pyrseas.augment.column.CfgColumnDict method) (pyrseas.augment.function.CfgFunctionDict method) (pyrseas.augment.schema.AugSchemaDict method) (pyrseas.augment.table.AugClassDict method) (pyrseas.augment.trigger.CfgTriggerDict method) (pyrseas.database.Database method) (pyrseas.dbobject.cast.CastDict method) (pyrseas.dbobject.collation.CollationDict method) (pyrseas.dbobject.column.ColumnDict method) (pyrseas.dbobject.constraint.ConstraintDict method) (pyrseas.dbobject.conversion.ConversionDict method) (pyrseas.dbobject.dbtype.TypeDict method) (pyrseas.dbobject.eventtrig.EventTriggerDict method) (pyrseas.dbobject.extension.ExtensionDict method) (pyrseas.dbobject.foreign.ForeignDataWrapperDict method) (pyrseas.dbobject.foreign.ForeignServerDict method) (pyrseas.dbobject.foreign.ForeignTableDict method) (pyrseas.dbobject.foreign.UserMappingDict method) (pyrseas.dbobject.function.ProcDict method) (pyrseas.dbobject.index.IndexDict method) (pyrseas.dbobject.language.LanguageDict method) (pyrseas.dbobject.operator.OperatorDict method) (pyrseas.dbobject.operclass.OperatorClassDict method) (pyrseas.dbobject.operfamily.OperatorFamilyDict method) (pyrseas.dbobject.rule.RuleDict method) (pyrseas.dbobject.schema.SchemaDict method) (pyrseas.dbobject.table.ClassDict method) (pyrseas.dbobject.textsearch.TSConfigurationDict method) (pyrseas.dbobject.textsearch.TSDictionaryDict method) (pyrseas.dbobject.textsearch.TSParserDict method) (pyrseas.dbobject.textsearch.TSTemplateDict method) (pyrseas.dbobject.trigger.TriggerDict method) Function (class in pyrseas.dbobject.function)

G

get_attrs() (pyrseas.dbobject.table.Sequence method)

get_dependent_table() (pyrseas.dbobject.table.Sequence method)

I

identifier() (pyrseas.dbobject.cast.Cast method) (pyrseas.dbobject.DbObject method) (pyrseas.dbobject.DbSchemaObject method) (pyrseas.dbobject.foreign.ForeignServer method) (pyrseas.dbobject.foreign.UserMapping method) (pyrseas.dbobject.function.Proc method) (pyrseas.dbobject.operator.Operator method) (pyrseas.dbobject.operclass.OperatorClass method) (pyrseas.dbobject.operfamily.OperatorFamily method) (pyrseas.dbobject.rule.Rule method) (pyrseas.dbobject.trigger.Trigger method) Index (class in pyrseas.dbobject.index)

IndexDict (class in pyrseas.dbobject.index)

K

key() (pyrseas.dbobject.DbObject method) key_columns() (pyrseas.dbobject.constraint.Constraint method)

key_expressions() (pyrseas.dbobject.index.Index method) keylist (pyrseas.dbobject.DbObject attribute)

L

Language (class in pyrseas.dbobject.language) LanguageDict (class in pyrseas.dbobject.language)

link_current() (pyrseas.augment.schema.AugSchemaDict method) (pyrseas.augment.table.AugClassDict method) link_refs() (pyrseas.augment.schema.AugSchemaDict method) (pyrseas.dbobject.dbtype.TypeDict method) (pyrseas.dbobject.foreign.ForeignDataWrapperDict method) (pyrseas.dbobject.foreign.ForeignServerDict method) (pyrseas.dbobject.foreign.ForeignTableDict method) (pyrseas.dbobject.language.LanguageDict method) (pyrseas.dbobject.schema.SchemaDict method) (pyrseas.dbobject.table.ClassDict method)

M

map_from_dir() (pyrseas.database.Database method) map_privs() (pyrseas.dbobject.DbObject method)

MaterializedView (class in pyrseas.dbobject.table)

O

objtype (pyrseas.dbobject.DbObject attribute) Operator (class in pyrseas.dbobject.operator) OperatorClass (class in pyrseas.dbobject.operclass) OperatorClassDict (class in pyrseas.dbobject.operclass)

OperatorDict (class in pyrseas.dbobject.operator) OperatorFamily (class in pyrseas.dbobject.operfamily) OperatorFamilyDict (class in pyrseas.dbobject.operfamily) options_clause() (pyrseas.dbobject.foreign.DbObjectWithOptions method)

P

PrimaryKey (class in pyrseas.dbobject.constraint) Proc (class in pyrseas.dbobject.function) ProcDict (class in pyrseas.dbobject.function) pyrseas.augment.audit (module) pyrseas.augment.column (module) pyrseas.augment.function (module) pyrseas.augment.schema (module) pyrseas.augment.table (module) pyrseas.augment.trigger (module) pyrseas.augmentdb (module) pyrseas.database (module) pyrseas.dbobject (module) pyrseas.dbobject.cast (module) pyrseas.dbobject.collation (module) pyrseas.dbobject.column (module) pyrseas.dbobject.constraint (module) pyrseas.dbobject.conversion (module)

pyrseas.dbobject.dbtype (module) pyrseas.dbobject.eventtrig (module) pyrseas.dbobject.extension (module) pyrseas.dbobject.foreign (module) pyrseas.dbobject.function (module) pyrseas.dbobject.index (module) pyrseas.dbobject.language (module) pyrseas.dbobject.operator (module) pyrseas.dbobject.operclass (module) pyrseas.dbobject.operfamily (module) pyrseas.dbobject.rule (module) pyrseas.dbobject.schema (module) pyrseas.dbobject.table (module) pyrseas.dbobject.textsearch (module) pyrseas.dbobject.trigger (module) pyrseas.lib.dbconn (module)

Q

qualname() (pyrseas.dbobject.DbSchemaObject method) (pyrseas.dbobject.operator.Operator method)

query (pyrseas.dbobject.DbObjectDict attribute)

R

ref_columns() (pyrseas.dbobject.constraint.ForeignKey method) rename() (pyrseas.dbobject.column.Column method) (pyrseas.dbobject.DbObject method) (pyrseas.dbobject.DbSchemaObject method) rollback() (pyrseas.lib.dbconn.DbConnection method)

Rule (class in pyrseas.dbobject.rule) RuleDict (class in pyrseas.dbobject.rule)

S

Schema (class in pyrseas.dbobject.schema) SchemaDict (class in pyrseas.dbobject.schema)

Sequence (class in pyrseas.dbobject.table) set_sequence_default() (pyrseas.dbobject.column.Column method)

T

Table (class in pyrseas.dbobject.table) to_map() (pyrseas.database.Database method) (pyrseas.dbobject.DbObject method) (pyrseas.dbobject.DbObjectDict method) (pyrseas.dbobject.cast.Cast method) (pyrseas.dbobject.column.Column method) (pyrseas.dbobject.constraint.CheckConstraint method) (pyrseas.dbobject.constraint.ForeignKey method) (pyrseas.dbobject.constraint.PrimaryKey method) (pyrseas.dbobject.constraint.UniqueConstraint method) (pyrseas.dbobject.dbtype.BaseType method) (pyrseas.dbobject.dbtype.Composite method) (pyrseas.dbobject.dbtype.Domain method) (pyrseas.dbobject.foreign.ForeignDataWrapper method) (pyrseas.dbobject.foreign.ForeignServer method) (pyrseas.dbobject.foreign.ForeignServerDict method) (pyrseas.dbobject.foreign.ForeignTable method) (pyrseas.dbobject.foreign.UserMappingDict method) (pyrseas.dbobject.function.Aggregate method) (pyrseas.dbobject.function.Function method) (pyrseas.dbobject.index.Index method) (pyrseas.dbobject.language.Language method) (pyrseas.dbobject.operclass.OperatorClass method) (pyrseas.dbobject.rule.Rule method) (pyrseas.dbobject.schema.Schema method) (pyrseas.dbobject.schema.SchemaDict method) (pyrseas.dbobject.table.MaterializedView method) (pyrseas.dbobject.table.Sequence method) (pyrseas.dbobject.table.Table method) (pyrseas.dbobject.table.View method) (pyrseas.dbobject.textsearch.TSConfiguration method) (pyrseas.dbobject.trigger.Trigger method) Trigger (class in pyrseas.dbobject.trigger) TriggerDict (class in pyrseas.dbobject.trigger) TSConfiguration (class in pyrseas.dbobject.textsearch) TSConfigurationDict (class in pyrseas.dbobject.textsearch) TSDictionary (class in pyrseas.dbobject.textsearch)

TSDictionaryDict (class in pyrseas.dbobject.textsearch) TSParser (class in pyrseas.dbobject.textsearch) TSParserDict (class in pyrseas.dbobject.textsearch) TSTemplate (class in pyrseas.dbobject.textsearch) TSTemplateDict (class in pyrseas.dbobject.textsearch) TypeDict (class in pyrseas.dbobject.dbtype)

U

UniqueConstraint (class in pyrseas.dbobject.constraint) unqualify() (pyrseas.dbobject.DbSchemaObject method)

UserMapping (class in pyrseas.dbobject.foreign) UserMappingDict (class in pyrseas.dbobject.foreign)

V

View (class in pyrseas.dbobject.table)

Y

yamltodb command line option --quote-reserved --schema <schema> --single-transaction -1 -m, --multiple-files -n <schema> -u, --update