Results of 1 - 1 of about 1 for postgresscanner (0.001 sec.)
- PostgreSQL Extension 9414
- The postgres extension allows DuckDB to directly read and write data from a running PostgreSQL database instance. The data can be queried directly from the underlying PostgreSQL database. Data can be loaded from PostgreSQL tables into DuckD
...gs and commonly used parameters. A full list of available parameters can be found in the PostgreSQL documentation . dbname=postgresscanner host=localhost port=5432 dbname=mydb connect_timeout=10 Name Description Default dbname Database name [user] host Name of...into PostgreSQL. Below is a brief example of how to create a new table in PostgreSQL and load data into it. ATTACH 'dbname=postgresscanner' AS postgres_db (TYPE postgres); CREATE TABLE postgres_db.tbl (id INTEGER, name VARCHAR); INSERT INTO postgres_db.tbl VALU...un with the READ_ONLY property which prevents making modifications to the underlying database. For example: ATTACH 'dbname=postgresscanner' AS postgres_db (TYPE postgres, READ_ONLY); Below is a list of supported operations. CREATE TABLE CREATE TABLE postgres_db... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/overview.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work