def get_tables_with_oids_for_current_db()

in postgresql_metrics/postgres_queries.py [0:0]


def get_tables_with_oids_for_current_db(conn):
    tables = []
    results = query(conn,
                    "SELECT oid, relname FROM pg_class WHERE relkind = 'r' "
                    "AND relname NOT LIKE 'pg_%' AND relname NOT LIKE 'sql_%'")
    for result in results:
        table_oid, table_name = result
        tables.append((table_oid, table_name))
    return tables