postgres_scanner
postgres_scanner copied to clipboard
duckdb
Implements limit pushdown https://github.com/duckdb/duckdb-postgres/issues/233 Gets applied on all postgres attached queries, if preferred can be applied only when an option like experimental pushdown is set, however in this implementation triggers...
Fixes https://github.com/duckdb/duckdb-postgres/issues/298 ```bash postgres_execute(db, query, use_transaction=TRUE); postgres_query(db, query, use_transaction=TRUE); ``` `use_transaction` is an optional named parameter and set to true by default. If it is not mentioned, no behavior changes....
### What happens? Original issue reported on discord. This doesn't work. ``` CREATE TABLE postgres_db.my_schema.my_table AS SELECT ST_Point (.22, 1.22) AS geom -- Failed to copy data: ERROR: Unknown WKB...
### What happens? duckdb cant perform an upsert on a postgresql table. Ive tried to run: ``` duckdb.sql(f""" INSERT INTO postgres_db.old_dim ({', '.join(column_names)}) SELECT {', '.join(column_names)} FROM temp_rel ON CONFLICT...
### What happens? When using DuckDB 1.2.0, I receive an internal if I combine limit and order by in a query to an attached postgres (cloud SQL) database. The below...
I think it would make sense to have an option called `pg_use_transaction` that allows you to disable transactions. For example, in this issue: https://github.com/duckdb/duckdb-postgres/issues/285 not having the option to disable...
Hi, thank you for this super useful extension! I noticed that if I query a JSON or JSONB Postgres column, the type in DuckDB is VARCHAR. I was wondering if...
The [Postgres extension](https://duckdb.org/docs/stable/extensions/postgres.html#configuration) page for Postgres mentions you can use URIs to connect, but I can't seem to be able to use them to work with Secrets. It'd be great...
Hi all, I'm having some issues connecting to Google Cloud Platform Cloud SQL postgress database using postgres scanner extension for **Alpine**. To start with, I cannot install musle supported postgres...
## Software versions **Postgres**: 13.16 **Python**: 3.13.0 **DuckDB**: 1.2.0 ## Issue I have the following SQL script attempting to insert into a Postgres table `my_table` all data from a local...
