PostgresOSM.read_table

PostgresOSM.read_table(table_name, schema_name='public', condition=None, chunk_size=None, sorted_by=None, **kwargs)

Read data from a table of the database being connected.

See also [SQL-P-RT-1].

Parameters

  • table_name (str) – name of a table

  • schema_name (str) – name of a schema, defaults to 'public'

  • condition (str or None) – defaults to None

  • chunk_size (int or None) – number of rows to include in each chunk, defaults to None

  • sorted_by (str or None) – name(s) of a column (or columns) by which the retrieved data is sorted, defaults to None

  • kwargs – optional parameters of pandas.read_sql

Returns

data frame from the specified table

Return type

pandas.DataFrame

See the example for the method .read_sql_query().