PostgreSQL.read_table
- PostgreSQL.read_table(table_name, schema_name=None, conditions=None, chunk_size=None, sorted_by=None, **kwargs)
Read data from a table.
See also [DBMS-PS-RT-1].
- Parameters
table_name (str) – name of a table
schema_name (str) – name of a schema; when
schema_name=None
(default), it defaults toDEFAULT_SCHEMA
(i.e.'public'
)conditions (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 the method
read_sql_query()
or the function pandas.read_sql()
- Returns
data frame from the specified table
- Return type
pandas.DataFrame
See also
Examples for the method
PostgreSQL.read_sql_query()
.