PostgreSQL.read_table

PostgreSQL.read_table(table_name, schema_name=None, conditions=None, chunk_size=None, sorted_by=None, **kwargs)[source]

Read data from a specified table.

See also [DBMS-PS-RT-1].

Parameters:

  • table_name (str) – Name of the table.

  • schema_name (str | None) – Name of the schema; if schema_name=None, it defaults to DEFAULT_SCHEMA (i.e., 'public').

  • conditions (str | None) – SQL conditions to filter rows; defaults to None.

  • chunk_size (int | None) – Number of rows to fetch per iteration; defaults to None.

  • sorted_by (str | None) – Name(s) of column(s) by which the retrieved data is sorted; defaults to None.

  • kwargs – [Optional] Additional parameters for the method read_sql_query() or the function pandas.read_sql().

Returns:

Data of the specified table.

Return type:

pandas.DataFrame

See also