JsonPostgres

class bach.SeriesJsonPostgresโ€‹

(engine, base_node, index, name, expression, group_by, order_by, instance_dtype, **kwargs)

โ€‹[source]

A special Series that represents the โ€˜jsonโ€™ database type on Postgres.

note

Generally, it is advised to use JsonSeries instead. Given a SeriesJsonPostgres object, calling json_series_pg.astype(โ€˜jsonโ€™) will return a JsonSeries class representing the same data.

When json data is encountered in a sql table, this dtype is used. On Postgres for all operations the data is first cast to jsonb type. Therefore, it is recommended to cast to JsonSeries directly.

The public interface of this class is the same as the SeriesJson class. See the docstring of that class for more information.

Methodsโ€‹