postgres_scanner
postgres_scanner copied to clipboard
duckdb
### What happens? ERROR: deletes on append-only tables are not supported in serializable transactions ### To Reproduce I am computing in DuckDB and then writing the results back to Greenplum....
Synchronized snapshots are supported on replicas starting with PostgreSQL 10, and they're also supported in RDS/Aurora. The change in Postgres 10 didn't make it into the release notes, but I...
### What happens? If I do `SELECT * FROM pg.very_large_table LIMIT 1;` the query issued does not include a limit and thus the entire table is copied. ### To Reproduce...
### What happens? I have attached 2 Postgres databases (PG14 and PG15) and able to run queries on both databases. PG15 database is empty and does not have any tables....
### What happens? trying to create a table in a remote Postgis database wuth `create table postgres_db.test_table (id int, location geometry );` duckdb return a generic error: ``` INTERNAL Error:...
### What happens? When I execute a `SELECT` statement on a PostgreSQL table with a JSONB-type column that includes an output column for a field in that column (extracted via...
### What happens? I can connect to and copy tables from a PostgreSQL (running in Docker on my laptop), but if I try to copy the database I get a...
Nice to have possibilities to pass parameters through duckdb direct to the complex posgres query like ``` with pgdata as ( select * from postgres_query(pg, $$select * from some_pg_table where...
Hi there! I am trying to install the extension but I got 403 error as follows: ``` > dbExecute(con, "INSTALL postgres_scanner;") Error in `duckdb_result()`: ! rapi_execute: Failed to run query...
If I have a postgres server attached at `my_pg_db`, I want to be able to do `CREATE TEMP TABLE my_pg_db.public.tmp_table AS SELECT my_col from my_pg_db.public.original`, and have this create a...
