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","."]
code: def __init__(self, name: str, **kwargs):
      super().__init__(name=name, **kwargs)
      self.connect()
  
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 1 to create a new PgVectorHandler object from inherited base classes: VectorStoreHandler, PostgresHandler with example: obj = PgVectorHandler(name)