class_docstr: This handler handles connection and execution of the PostgreSQL statements.
docstr: List all tables in PostgreSQL without the system tables information_schema and pg_catalog
docstr_tok: ["List","all","tables","in","PostgreSQL","without","the","system","tables","information_schema","and","pg_catalog"]
code: def get_tables(self) -> Response:
      """
      List all tables in PostgreSQL without the system tables information_schema and pg_catalog
      """
      query = """
              SELECT
                  table_schema,
                  table_name,
                  table_type
              FROM
                  information_schema.tables
              WHERE
                  table_schema NOT IN ('information_schema', 'pg_catalog')
                  and table_type in ('BASE TABLE', 'VIEW')
                  and table_schema = current_schema()
          """
      return self.native_query(query)
  
imports: from collections import OrderedDict
  import psycopg
  from psycopg.postgres import types
  from psycopg.pq import ExecStatus
  from pandas import DataFrame
  from mindsdb_sql import parse_sql
  from mindsdb_sql.render.sqlalchemy_render import SqlalchemyRender
  from mindsdb_sql.parser.ast.base import ASTNode
  from mindsdb.integrations.libs.base import DatabaseHandler
  from mindsdb.integrations.libs.const import HANDLER_CONNECTION_ARG_TYPE
  from mindsdb.utilities import log
  from mindsdb.integrations.libs.response import HandlerStatusResponse, HandlerResponse, RESPONSE_TYPE
  import mindsdb.utilities.profiler
label_desc: Use image node_id 9 for calling the PostgresHandler obj's underlying member method code with example usage: obj.get_tables() and returns: self