{ "content": [ { "type": "text", "text": "# _pg (pydoc)\n\n## NAME\n\npg - Python interface to PostgreSQL DB\n\n## Sections\n\n- **NAME**\n- **CLASSES** (13 subsections)\n- **FUNCTIONS** (33 subsections)\n- **DATA**\n- **VERSION**\n- **FILE**\n\nUse structuredContent.sections for detailed options, examples, and full documentation.\n" } ], "structuredContent": { "command": "_pg", "section": "", "mode": "pydoc", "summary": "pg - Python interface to PostgreSQL DB", "synopsis": null, "tldr_summary": null, "tldr_examples": [], "tldr_source": null, "flags": [], "examples": [], "see_also": [], "section_outline": [ { "name": "NAME", "lines": 2, "subsections": [] }, { "name": "CLASSES", "lines": 15, "subsections": [ { "name": "class DataError", "lines": 69 }, { "name": "class DatabaseError", "lines": 68 }, { "name": "class Error", "lines": 67 }, { "name": "class IntegrityError", "lines": 69 }, { "name": "class InterfaceError", "lines": 68 }, { "name": "class InternalError", "lines": 69 }, { "name": "class InvalidResultError", "lines": 70 }, { "name": "class MultipleResultsError", "lines": 71 }, { "name": "class NoResultError", "lines": 71 }, { "name": "class NotSupportedError", "lines": 69 }, { "name": "class OperationalError", "lines": 69 }, { "name": "class ProgrammingError", "lines": 69 }, { "name": "class Warning", "lines": 67 } ] }, { "name": "FUNCTIONS", "lines": 1, "subsections": [ { "name": "cast_array", "lines": 2 }, { "name": "cast_hstore", "lines": 2 }, { "name": "cast_record", "lines": 2 }, { "name": "connect", "lines": 4 }, { "name": "escape_bytea", "lines": 2 }, { "name": "escape_string", "lines": 2 }, { "name": "get_array", "lines": 2 }, { "name": "get_bool", "lines": 2 }, { "name": "get_bytea_escaped", "lines": 2 }, { "name": "get_datestyle", "lines": 2 }, { "name": "get_decimal", "lines": 2 }, { "name": "get_decimal_point", "lines": 2 }, { "name": "get_defbase", "lines": 2 }, { "name": "get_defhost", "lines": 2 }, { "name": "get_defopt", "lines": 2 }, { "name": "get_defport", "lines": 2 }, { "name": "get_defuser", "lines": 2 }, { "name": "get_jsondecode", "lines": 2 }, { "name": "set_array", "lines": 2 }, { "name": "set_bool", "lines": 2 }, { "name": "set_bytea_escaped", "lines": 2 }, { "name": "set_datestyle", "lines": 2 }, { "name": "set_decimal", "lines": 2 }, { "name": "set_decimal_point", "lines": 2 }, { "name": "set_defbase", "lines": 2 }, { "name": "set_defhost", "lines": 2 }, { "name": "set_defopt", "lines": 2 }, { "name": "set_defpasswd", "lines": 2 }, { "name": "set_defport", "lines": 2 }, { "name": "set_defuser", "lines": 2 }, { "name": "set_jsondecode", "lines": 2 }, { "name": "set_query_helpers", "lines": 2 }, { "name": "unescape_bytea", "lines": 2 } ] }, { "name": "DATA", "lines": 16, "subsections": [] }, { "name": "VERSION", "lines": 2, "subsections": [] }, { "name": "FILE", "lines": 3, "subsections": [] } ], "sections": { "NAME": { "content": "pg - Python interface to PostgreSQL DB\n", "subsections": [] }, "CLASSES": { "content": "builtins.Exception(builtins.BaseException)\npg.Error\npg.DatabaseError\npg.DataError\npg.InvalidResultError\npg.MultipleResultsError\npg.NoResultError\npg.IntegrityError\npg.InternalError\npg.NotSupportedError\npg.OperationalError\npg.ProgrammingError\npg.InterfaceError\npg.Warning\n", "subsections": [ { "name": "class DataError", "content": "| Method resolution order:\n| DataError\n| DatabaseError\n| Error\n| builtins.Exception\n| builtins.BaseException\n| builtins.object\n|\n| Data descriptors inherited from Error:\n|\n| weakref\n| list of weak references to the object (if defined)\n|\n| ----------------------------------------------------------------------\n| Methods inherited from builtins.Exception:\n|\n| init(self, /, *args, kwargs)\n| Initialize self. See help(type(self)) for accurate signature.\n|\n| ----------------------------------------------------------------------\n| Static methods inherited from builtins.Exception:\n|\n| new(*args, kwargs) from builtins.type\n| Create and return a new object. See help(type) for accurate signature.\n|\n| ----------------------------------------------------------------------\n| Methods inherited from builtins.BaseException:\n|\n| delattr(self, name, /)\n| Implement delattr(self, name).\n|\n| getattribute(self, name, /)\n| Return getattr(self, name).\n|\n| reduce(...)\n| Helper for pickle.\n|\n| repr(self, /)\n| Return repr(self).\n|\n| setattr(self, name, value, /)\n| Implement setattr(self, name, value).\n|\n| setstate(...)\n|\n| str(self, /)\n| Return str(self).\n|\n| withtraceback(...)\n| Exception.withtraceback(tb) --\n| set self.traceback to tb and return self.\n|\n| ----------------------------------------------------------------------\n| Data descriptors inherited from builtins.BaseException:\n|\n| cause\n| exception cause\n|\n| context\n| exception context\n|\n| dict\n|\n| suppresscontext\n|\n| traceback\n|\n| args\n" }, { "name": "class DatabaseError", "content": "| Method resolution order:\n| DatabaseError\n| Error\n| builtins.Exception\n| builtins.BaseException\n| builtins.object\n|\n| Data descriptors inherited from Error:\n|\n| weakref\n| list of weak references to the object (if defined)\n|\n| ----------------------------------------------------------------------\n| Methods inherited from builtins.Exception:\n|\n| init(self, /, *args, kwargs)\n| Initialize self. See help(type(self)) for accurate signature.\n|\n| ----------------------------------------------------------------------\n| Static methods inherited from builtins.Exception:\n|\n| new(*args, kwargs) from builtins.type\n| Create and return a new object. See help(type) for accurate signature.\n|\n| ----------------------------------------------------------------------\n| Methods inherited from builtins.BaseException:\n|\n| delattr(self, name, /)\n| Implement delattr(self, name).\n|\n| getattribute(self, name, /)\n| Return getattr(self, name).\n|\n| reduce(...)\n| Helper for pickle.\n|\n| repr(self, /)\n| Return repr(self).\n|\n| setattr(self, name, value, /)\n| Implement setattr(self, name, value).\n|\n| setstate(...)\n|\n| str(self, /)\n| Return str(self).\n|\n| withtraceback(...)\n| Exception.withtraceback(tb) --\n| set self.traceback to tb and return self.\n|\n| ----------------------------------------------------------------------\n| Data descriptors inherited from builtins.BaseException:\n|\n| cause\n| exception cause\n|\n| context\n| exception context\n|\n| dict\n|\n| suppresscontext\n|\n| traceback\n|\n| args\n" }, { "name": "class Error", "content": "| Method resolution order:\n| Error\n| builtins.Exception\n| builtins.BaseException\n| builtins.object\n|\n| Data descriptors defined here:\n|\n| weakref\n| list of weak references to the object (if defined)\n|\n| ----------------------------------------------------------------------\n| Methods inherited from builtins.Exception:\n|\n| init(self, /, *args, kwargs)\n| Initialize self. See help(type(self)) for accurate signature.\n|\n| ----------------------------------------------------------------------\n| Static methods inherited from builtins.Exception:\n|\n| new(*args, kwargs) from builtins.type\n| Create and return a new object. See help(type) for accurate signature.\n|\n| ----------------------------------------------------------------------\n| Methods inherited from builtins.BaseException:\n|\n| delattr(self, name, /)\n| Implement delattr(self, name).\n|\n| getattribute(self, name, /)\n| Return getattr(self, name).\n|\n| reduce(...)\n| Helper for pickle.\n|\n| repr(self, /)\n| Return repr(self).\n|\n| setattr(self, name, value, /)\n| Implement setattr(self, name, value).\n|\n| setstate(...)\n|\n| str(self, /)\n| Return str(self).\n|\n| withtraceback(...)\n| Exception.withtraceback(tb) --\n| set self.traceback to tb and return self.\n|\n| ----------------------------------------------------------------------\n| Data descriptors inherited from builtins.BaseException:\n|\n| cause\n| exception cause\n|\n| context\n| exception context\n|\n| dict\n|\n| suppresscontext\n|\n| traceback\n|\n| args\n" }, { "name": "class IntegrityError", "content": "| Method resolution order:\n| IntegrityError\n| DatabaseError\n| Error\n| builtins.Exception\n| builtins.BaseException\n| builtins.object\n|\n| Data descriptors inherited from Error:\n|\n| weakref\n| list of weak references to the object (if defined)\n|\n| ----------------------------------------------------------------------\n| Methods inherited from builtins.Exception:\n|\n| init(self, /, *args, kwargs)\n| Initialize self. See help(type(self)) for accurate signature.\n|\n| ----------------------------------------------------------------------\n| Static methods inherited from builtins.Exception:\n|\n| new(*args, kwargs) from builtins.type\n| Create and return a new object. See help(type) for accurate signature.\n|\n| ----------------------------------------------------------------------\n| Methods inherited from builtins.BaseException:\n|\n| delattr(self, name, /)\n| Implement delattr(self, name).\n|\n| getattribute(self, name, /)\n| Return getattr(self, name).\n|\n| reduce(...)\n| Helper for pickle.\n|\n| repr(self, /)\n| Return repr(self).\n|\n| setattr(self, name, value, /)\n| Implement setattr(self, name, value).\n|\n| setstate(...)\n|\n| str(self, /)\n| Return str(self).\n|\n| withtraceback(...)\n| Exception.withtraceback(tb) --\n| set self.traceback to tb and return self.\n|\n| ----------------------------------------------------------------------\n| Data descriptors inherited from builtins.BaseException:\n|\n| cause\n| exception cause\n|\n| context\n| exception context\n|\n| dict\n|\n| suppresscontext\n|\n| traceback\n|\n| args\n" }, { "name": "class InterfaceError", "content": "| Method resolution order:\n| InterfaceError\n| Error\n| builtins.Exception\n| builtins.BaseException\n| builtins.object\n|\n| Data descriptors inherited from Error:\n|\n| weakref\n| list of weak references to the object (if defined)\n|\n| ----------------------------------------------------------------------\n| Methods inherited from builtins.Exception:\n|\n| init(self, /, *args, kwargs)\n| Initialize self. See help(type(self)) for accurate signature.\n|\n| ----------------------------------------------------------------------\n| Static methods inherited from builtins.Exception:\n|\n| new(*args, kwargs) from builtins.type\n| Create and return a new object. See help(type) for accurate signature.\n|\n| ----------------------------------------------------------------------\n| Methods inherited from builtins.BaseException:\n|\n| delattr(self, name, /)\n| Implement delattr(self, name).\n|\n| getattribute(self, name, /)\n| Return getattr(self, name).\n|\n| reduce(...)\n| Helper for pickle.\n|\n| repr(self, /)\n| Return repr(self).\n|\n| setattr(self, name, value, /)\n| Implement setattr(self, name, value).\n|\n| setstate(...)\n|\n| str(self, /)\n| Return str(self).\n|\n| withtraceback(...)\n| Exception.withtraceback(tb) --\n| set self.traceback to tb and return self.\n|\n| ----------------------------------------------------------------------\n| Data descriptors inherited from builtins.BaseException:\n|\n| cause\n| exception cause\n|\n| context\n| exception context\n|\n| dict\n|\n| suppresscontext\n|\n| traceback\n|\n| args\n" }, { "name": "class InternalError", "content": "| Method resolution order:\n| InternalError\n| DatabaseError\n| Error\n| builtins.Exception\n| builtins.BaseException\n| builtins.object\n|\n| Data descriptors inherited from Error:\n|\n| weakref\n| list of weak references to the object (if defined)\n|\n| ----------------------------------------------------------------------\n| Methods inherited from builtins.Exception:\n|\n| init(self, /, *args, kwargs)\n| Initialize self. See help(type(self)) for accurate signature.\n|\n| ----------------------------------------------------------------------\n| Static methods inherited from builtins.Exception:\n|\n| new(*args, kwargs) from builtins.type\n| Create and return a new object. See help(type) for accurate signature.\n|\n| ----------------------------------------------------------------------\n| Methods inherited from builtins.BaseException:\n|\n| delattr(self, name, /)\n| Implement delattr(self, name).\n|\n| getattribute(self, name, /)\n| Return getattr(self, name).\n|\n| reduce(...)\n| Helper for pickle.\n|\n| repr(self, /)\n| Return repr(self).\n|\n| setattr(self, name, value, /)\n| Implement setattr(self, name, value).\n|\n| setstate(...)\n|\n| str(self, /)\n| Return str(self).\n|\n| withtraceback(...)\n| Exception.withtraceback(tb) --\n| set self.traceback to tb and return self.\n|\n| ----------------------------------------------------------------------\n| Data descriptors inherited from builtins.BaseException:\n|\n| cause\n| exception cause\n|\n| context\n| exception context\n|\n| dict\n|\n| suppresscontext\n|\n| traceback\n|\n| args\n" }, { "name": "class InvalidResultError", "content": "| Method resolution order:\n| InvalidResultError\n| DataError\n| DatabaseError\n| Error\n| builtins.Exception\n| builtins.BaseException\n| builtins.object\n|\n| Data descriptors inherited from Error:\n|\n| weakref\n| list of weak references to the object (if defined)\n|\n| ----------------------------------------------------------------------\n| Methods inherited from builtins.Exception:\n|\n| init(self, /, *args, kwargs)\n| Initialize self. See help(type(self)) for accurate signature.\n|\n| ----------------------------------------------------------------------\n| Static methods inherited from builtins.Exception:\n|\n| new(*args, kwargs) from builtins.type\n| Create and return a new object. See help(type) for accurate signature.\n|\n| ----------------------------------------------------------------------\n| Methods inherited from builtins.BaseException:\n|\n| delattr(self, name, /)\n| Implement delattr(self, name).\n|\n| getattribute(self, name, /)\n| Return getattr(self, name).\n|\n| reduce(...)\n| Helper for pickle.\n|\n| repr(self, /)\n| Return repr(self).\n|\n| setattr(self, name, value, /)\n| Implement setattr(self, name, value).\n|\n| setstate(...)\n|\n| str(self, /)\n| Return str(self).\n|\n| withtraceback(...)\n| Exception.withtraceback(tb) --\n| set self.traceback to tb and return self.\n|\n| ----------------------------------------------------------------------\n| Data descriptors inherited from builtins.BaseException:\n|\n| cause\n| exception cause\n|\n| context\n| exception context\n|\n| dict\n|\n| suppresscontext\n|\n| traceback\n|\n| args\n" }, { "name": "class MultipleResultsError", "content": "| Method resolution order:\n| MultipleResultsError\n| InvalidResultError\n| DataError\n| DatabaseError\n| Error\n| builtins.Exception\n| builtins.BaseException\n| builtins.object\n|\n| Data descriptors inherited from Error:\n|\n| weakref\n| list of weak references to the object (if defined)\n|\n| ----------------------------------------------------------------------\n| Methods inherited from builtins.Exception:\n|\n| init(self, /, *args, kwargs)\n| Initialize self. See help(type(self)) for accurate signature.\n|\n| ----------------------------------------------------------------------\n| Static methods inherited from builtins.Exception:\n|\n| new(*args, kwargs) from builtins.type\n| Create and return a new object. See help(type) for accurate signature.\n|\n| ----------------------------------------------------------------------\n| Methods inherited from builtins.BaseException:\n|\n| delattr(self, name, /)\n| Implement delattr(self, name).\n|\n| getattribute(self, name, /)\n| Return getattr(self, name).\n|\n| reduce(...)\n| Helper for pickle.\n|\n| repr(self, /)\n| Return repr(self).\n|\n| setattr(self, name, value, /)\n| Implement setattr(self, name, value).\n|\n| setstate(...)\n|\n| str(self, /)\n| Return str(self).\n|\n| withtraceback(...)\n| Exception.withtraceback(tb) --\n| set self.traceback to tb and return self.\n|\n| ----------------------------------------------------------------------\n| Data descriptors inherited from builtins.BaseException:\n|\n| cause\n| exception cause\n|\n| context\n| exception context\n|\n| dict\n|\n| suppresscontext\n|\n| traceback\n|\n| args\n" }, { "name": "class NoResultError", "content": "| Method resolution order:\n| NoResultError\n| InvalidResultError\n| DataError\n| DatabaseError\n| Error\n| builtins.Exception\n| builtins.BaseException\n| builtins.object\n|\n| Data descriptors inherited from Error:\n|\n| weakref\n| list of weak references to the object (if defined)\n|\n| ----------------------------------------------------------------------\n| Methods inherited from builtins.Exception:\n|\n| init(self, /, *args, kwargs)\n| Initialize self. See help(type(self)) for accurate signature.\n|\n| ----------------------------------------------------------------------\n| Static methods inherited from builtins.Exception:\n|\n| new(*args, kwargs) from builtins.type\n| Create and return a new object. See help(type) for accurate signature.\n|\n| ----------------------------------------------------------------------\n| Methods inherited from builtins.BaseException:\n|\n| delattr(self, name, /)\n| Implement delattr(self, name).\n|\n| getattribute(self, name, /)\n| Return getattr(self, name).\n|\n| reduce(...)\n| Helper for pickle.\n|\n| repr(self, /)\n| Return repr(self).\n|\n| setattr(self, name, value, /)\n| Implement setattr(self, name, value).\n|\n| setstate(...)\n|\n| str(self, /)\n| Return str(self).\n|\n| withtraceback(...)\n| Exception.withtraceback(tb) --\n| set self.traceback to tb and return self.\n|\n| ----------------------------------------------------------------------\n| Data descriptors inherited from builtins.BaseException:\n|\n| cause\n| exception cause\n|\n| context\n| exception context\n|\n| dict\n|\n| suppresscontext\n|\n| traceback\n|\n| args\n" }, { "name": "class NotSupportedError", "content": "| Method resolution order:\n| NotSupportedError\n| DatabaseError\n| Error\n| builtins.Exception\n| builtins.BaseException\n| builtins.object\n|\n| Data descriptors inherited from Error:\n|\n| weakref\n| list of weak references to the object (if defined)\n|\n| ----------------------------------------------------------------------\n| Methods inherited from builtins.Exception:\n|\n| init(self, /, *args, kwargs)\n| Initialize self. See help(type(self)) for accurate signature.\n|\n| ----------------------------------------------------------------------\n| Static methods inherited from builtins.Exception:\n|\n| new(*args, kwargs) from builtins.type\n| Create and return a new object. See help(type) for accurate signature.\n|\n| ----------------------------------------------------------------------\n| Methods inherited from builtins.BaseException:\n|\n| delattr(self, name, /)\n| Implement delattr(self, name).\n|\n| getattribute(self, name, /)\n| Return getattr(self, name).\n|\n| reduce(...)\n| Helper for pickle.\n|\n| repr(self, /)\n| Return repr(self).\n|\n| setattr(self, name, value, /)\n| Implement setattr(self, name, value).\n|\n| setstate(...)\n|\n| str(self, /)\n| Return str(self).\n|\n| withtraceback(...)\n| Exception.withtraceback(tb) --\n| set self.traceback to tb and return self.\n|\n| ----------------------------------------------------------------------\n| Data descriptors inherited from builtins.BaseException:\n|\n| cause\n| exception cause\n|\n| context\n| exception context\n|\n| dict\n|\n| suppresscontext\n|\n| traceback\n|\n| args\n" }, { "name": "class OperationalError", "content": "| Method resolution order:\n| OperationalError\n| DatabaseError\n| Error\n| builtins.Exception\n| builtins.BaseException\n| builtins.object\n|\n| Data descriptors inherited from Error:\n|\n| weakref\n| list of weak references to the object (if defined)\n|\n| ----------------------------------------------------------------------\n| Methods inherited from builtins.Exception:\n|\n| init(self, /, *args, kwargs)\n| Initialize self. See help(type(self)) for accurate signature.\n|\n| ----------------------------------------------------------------------\n| Static methods inherited from builtins.Exception:\n|\n| new(*args, kwargs) from builtins.type\n| Create and return a new object. See help(type) for accurate signature.\n|\n| ----------------------------------------------------------------------\n| Methods inherited from builtins.BaseException:\n|\n| delattr(self, name, /)\n| Implement delattr(self, name).\n|\n| getattribute(self, name, /)\n| Return getattr(self, name).\n|\n| reduce(...)\n| Helper for pickle.\n|\n| repr(self, /)\n| Return repr(self).\n|\n| setattr(self, name, value, /)\n| Implement setattr(self, name, value).\n|\n| setstate(...)\n|\n| str(self, /)\n| Return str(self).\n|\n| withtraceback(...)\n| Exception.withtraceback(tb) --\n| set self.traceback to tb and return self.\n|\n| ----------------------------------------------------------------------\n| Data descriptors inherited from builtins.BaseException:\n|\n| cause\n| exception cause\n|\n| context\n| exception context\n|\n| dict\n|\n| suppresscontext\n|\n| traceback\n|\n| args\n" }, { "name": "class ProgrammingError", "content": "| Method resolution order:\n| ProgrammingError\n| DatabaseError\n| Error\n| builtins.Exception\n| builtins.BaseException\n| builtins.object\n|\n| Data descriptors inherited from Error:\n|\n| weakref\n| list of weak references to the object (if defined)\n|\n| ----------------------------------------------------------------------\n| Methods inherited from builtins.Exception:\n|\n| init(self, /, *args, kwargs)\n| Initialize self. See help(type(self)) for accurate signature.\n|\n| ----------------------------------------------------------------------\n| Static methods inherited from builtins.Exception:\n|\n| new(*args, kwargs) from builtins.type\n| Create and return a new object. See help(type) for accurate signature.\n|\n| ----------------------------------------------------------------------\n| Methods inherited from builtins.BaseException:\n|\n| delattr(self, name, /)\n| Implement delattr(self, name).\n|\n| getattribute(self, name, /)\n| Return getattr(self, name).\n|\n| reduce(...)\n| Helper for pickle.\n|\n| repr(self, /)\n| Return repr(self).\n|\n| setattr(self, name, value, /)\n| Implement setattr(self, name, value).\n|\n| setstate(...)\n|\n| str(self, /)\n| Return str(self).\n|\n| withtraceback(...)\n| Exception.withtraceback(tb) --\n| set self.traceback to tb and return self.\n|\n| ----------------------------------------------------------------------\n| Data descriptors inherited from builtins.BaseException:\n|\n| cause\n| exception cause\n|\n| context\n| exception context\n|\n| dict\n|\n| suppresscontext\n|\n| traceback\n|\n| args\n" }, { "name": "class Warning", "content": "| Method resolution order:\n| Warning\n| builtins.Exception\n| builtins.BaseException\n| builtins.object\n|\n| Data descriptors defined here:\n|\n| weakref\n| list of weak references to the object (if defined)\n|\n| ----------------------------------------------------------------------\n| Methods inherited from builtins.Exception:\n|\n| init(self, /, *args, kwargs)\n| Initialize self. See help(type(self)) for accurate signature.\n|\n| ----------------------------------------------------------------------\n| Static methods inherited from builtins.Exception:\n|\n| new(*args, kwargs) from builtins.type\n| Create and return a new object. See help(type) for accurate signature.\n|\n| ----------------------------------------------------------------------\n| Methods inherited from builtins.BaseException:\n|\n| delattr(self, name, /)\n| Implement delattr(self, name).\n|\n| getattribute(self, name, /)\n| Return getattr(self, name).\n|\n| reduce(...)\n| Helper for pickle.\n|\n| repr(self, /)\n| Return repr(self).\n|\n| setattr(self, name, value, /)\n| Implement setattr(self, name, value).\n|\n| setstate(...)\n|\n| str(self, /)\n| Return str(self).\n|\n| withtraceback(...)\n| Exception.withtraceback(tb) --\n| set self.traceback to tb and return self.\n|\n| ----------------------------------------------------------------------\n| Data descriptors inherited from builtins.BaseException:\n|\n| cause\n| exception cause\n|\n| context\n| exception context\n|\n| dict\n|\n| suppresscontext\n|\n| traceback\n|\n| args\n" } ] }, "FUNCTIONS": { "content": "", "subsections": [ { "name": "cast_array", "content": "castarray(string, cast=None, delim=',') -- cast a string as an array\n" }, { "name": "cast_hstore", "content": "casthstore(string) -- cast a string as an hstore\n" }, { "name": "cast_record", "content": "castrecord(string, cast=None, delim=',') -- cast a string as a record\n" }, { "name": "connect", "content": "connect(dbname, host, port, opt) -- connect to a PostgreSQL database\n\nThe connection uses the specified parameters (optional, keywords aware).\n" }, { "name": "escape_bytea", "content": "escapebytea(data) -- escape binary data for use within SQL as type bytea\n" }, { "name": "escape_string", "content": "escapestring(string) -- escape a string for use within SQL\n" }, { "name": "get_array", "content": "getarray() -- check whether arrays are converted as lists\n" }, { "name": "get_bool", "content": "getbool() -- check whether boolean values are converted to bool\n" }, { "name": "get_bytea_escaped", "content": "getbyteaescaped() -- check whether bytea will be returned escaped\n" }, { "name": "get_datestyle", "content": "getdatestyle() -- get which date style is assumed\n" }, { "name": "get_decimal", "content": "getdecimal() -- get the decimal type to be used for numeric values\n" }, { "name": "get_decimal_point", "content": "getdecimalpoint() -- get decimal point to be used for money values\n" }, { "name": "get_defbase", "content": "getdefbase() -- return default database name\n" }, { "name": "get_defhost", "content": "getdefhost() -- return default database host\n" }, { "name": "get_defopt", "content": "getdefopt() -- return default database options\n" }, { "name": "get_defport", "content": "getdefport() -- return default database port\n" }, { "name": "get_defuser", "content": "getdefuser() -- return default database username\n" }, { "name": "get_jsondecode", "content": "getjsondecode() -- get the function used for decoding json results\n" }, { "name": "set_array", "content": "setarray(on) -- set whether arrays should be converted to lists\n" }, { "name": "set_bool", "content": "setbool(on) -- set whether boolean values should be converted to bool\n" }, { "name": "set_bytea_escaped", "content": "setbyteaescaped(on) -- set whether bytea will be returned escaped\n" }, { "name": "set_datestyle", "content": "setdatestyle(style) -- set which style is assumed\n" }, { "name": "set_decimal", "content": "setdecimal(cls) -- set a decimal type to be used for numeric values\n" }, { "name": "set_decimal_point", "content": "setdecimalpoint(char) -- set decimal point to be used for money values\n" }, { "name": "set_defbase", "content": "setdefbase(string) -- set default database name and return previous value\n" }, { "name": "set_defhost", "content": "setdefhost(string) -- set default database host and return previous value\n" }, { "name": "set_defopt", "content": "setdefopt(string) -- set default options and return previous value\n" }, { "name": "set_defpasswd", "content": "setdefpasswd(password) -- set default database password\n" }, { "name": "set_defport", "content": "setdefport(port) -- set default port and return previous value\n" }, { "name": "set_defuser", "content": "setdefuser(name) -- set default username and return previous value\n" }, { "name": "set_jsondecode", "content": "setjsondecode(func) -- set a function to be used for decoding json results\n" }, { "name": "set_query_helpers", "content": "setqueryhelpers(*helpers) -- set internal query helper functions\n" }, { "name": "unescape_bytea", "content": "unescapebytea(string) -- unescape bytea data retrieved as text\n" } ] }, "DATA": { "content": "INVREAD = 262144\nINVWRITE = 131072\nRESULTDDL = 3\nRESULTDML = 2\nRESULTDQL = 4\nRESULTEMPTY = 1\nSEEKCUR = 1\nSEEKEND = 2\nSEEKSET = 0\nTRANSACTIVE = 1\nTRANSIDLE = 0\nTRANSINERROR = 3\nTRANSINTRANS = 2\nTRANSUNKNOWN = 4\nversion = '5.1.2'\n", "subsections": [] }, "VERSION": { "content": "5.1.2\n", "subsections": [] }, "FILE": { "content": "/usr/lib/python3/dist-packages/pg.cpython-310-x8664-linux-gnu.so\n\n", "subsections": [] } } } }