class_docstr: This handler handles connection and execution of the PostgreSQL with pgvector extension statements.
class_docstr_tok: ["This","handler","handles","connection","and","execution","of","the","PostgreSQL","with","pgvector","extension","statements","."]
docstr: Retrieve the data from the SQL statement with eliminated rows that dont satisfy the WHERE condition
docstr_tok: ["Retrieve","the","data","from","the","SQL","statement","with","eliminated","rows","that","dont","satisfy","the","WHERE","condition"]
code: def select(
      self,
      table_name: str,
      columns: List[str] = None,
      conditions: List[FilterCondition] = None,
      offset: int = None,
      limit: int = None,
  ) -> pd.DataFrame:
      """
      Retrieve the data from the SQL statement with eliminated rows that dont satisfy the WHERE condition
      """
      if columns is None:
          columns = ["id", "content", "embeddings", "metadata"]
  
      with self.connection.cursor() as cur:
          query = self._build_select_query(
              table_name, columns, conditions, limit, offset
          )
          cur.execute(query)
  
          self.connection.commit()
          result = cur.fetchall()
  
      result = pd.DataFrame(result, columns=columns)
      # ensure embeddings are returned as string so they can be parsed by mindsdb
      if "embeddings" in columns:
          result["embeddings"] = result["embeddings"].astype(str)
  
      return result
  
imports: from collections import OrderedDict
  from typing import List, Union
  import pandas
  import psycopg
  from mindsdb_sql import ASTNode, Parameter, Identifier, Update, BinaryOperation
  from pgvector.psycopg import register_vector
  from mindsdb.integrations.handlers.postgres_handler.postgres_handler import PostgresHandler
  from mindsdb.integrations.libs.const import HANDLER_CONNECTION_ARG_TYPE
  from mindsdb.integrations.libs.response import RESPONSE_TYPE
  from mindsdb.integrations.libs.response import HandlerResponse
  from mindsdb.integrations.libs.vectordatabase_handler import FilterCondition, VectorStoreHandler
  from mindsdb.utilities import log
  from mindsdb.utilities.profiler import profiler
label_desc: Use image node_id 7 for calling the PgVectorHandler obj's underlying member method code with example usage: obj.select(table_name, columns, conditions, offset, limit) and returns: result