Get table or view name metadata :param kinds: list of postgres relkind filters: 'r' - table 'p' - partitioned table 'f' - foreign table 'v' - view 'm' - materialized view :return: (schema_name, rel_name)
(self, kinds=("r", "p", "f", "v", "m"))
| 542 | return [x[0] for x in cur.fetchall()] |
| 543 | |
| 544 | def _relations(self, kinds=("r", "p", "f", "v", "m")): |
| 545 | """Get table or view name metadata |
| 546 | |
| 547 | :param kinds: list of postgres relkind filters: |
| 548 | 'r' - table |
| 549 | 'p' - partitioned table |
| 550 | 'f' - foreign table |
| 551 | 'v' - view |
| 552 | 'm' - materialized view |
| 553 | :return: (schema_name, rel_name) tuples |
| 554 | """ |
| 555 | |
| 556 | with self.conn.cursor() as cur: |
| 557 | # sql = cur.mogrify(self.tables_query, kinds) |
| 558 | # _logger.debug("Tables Query. sql: %r", sql) |
| 559 | cur.execute(self.tables_query, [kinds]) |
| 560 | yield from cur |
| 561 | |
| 562 | def tables(self): |
| 563 | """Yields (schema_name, table_name) tuples""" |