class documentation

class hstore(sqlfunc.GenericFunction):

View In Hierarchy

Construct an hstore value within a SQL expression using the PostgreSQL hstore() function.

The .hstore function accepts one or two arguments as described in the PostgreSQL documentation.

E.g.:

from sqlalchemy.dialects.postgresql import array, hstore

select(hstore('key1', 'value1'))

select(
    hstore(
        array(['key1', 'key2', 'key3']),
        array(['value1', 'value2', 'value3'])
    )
)

See Also

.HSTORE - the PostgreSQL HSTORE datatype.

Class Variable inherit​_cache Undocumented
Class Variable name Undocumented

Inherited from GenericFunction:

Method __init__ Undocumented
Class Variable ​_register Undocumented
Class Variable coerce​_arguments Undocumented
Instance Variable ​_bind Undocumented
Instance Variable ​_has​_args Undocumented
Instance Variable clause​_expr Undocumented
Instance Variable packagenames Undocumented
Instance Variable type Undocumented
inherit_cache: bool =
name: str =

Undocumented