Skip to main content

Postgres_Connection.tables

tablesname_likedatabaseschematypesall_fields

Group: Metadata

Documentation

Returns a materialized Table of all the matching views and tables.

Arguments

  • name_like: The table name pattern to search for. Supports SQL wildcards (%, _). Defaults to Nothing which means all tables are selected.
  • database: The database name to search in (default is current database).
  • schema: The schema name to search in (defaults to Nothing, meaning all schemas are searched).
  • types: The table types to search for. The list of possible values can be obtained using the table_types method. Defaults to a set of most commonly used table types, ignoring internal system tables or indices.
  • all_fields: Return all the fields in the metadata table.

Remarks

Temporary Tables

Note that the temporary tables may be created in a different schema than the current one, so take this into account when filtering by schema.