docker-pgredshift

docker-pgredshift copied to clipboard

Implement UNLOAD

1

https://docs.aws.amazon.com/redshift/latest/dg/r_UNLOAD.html Doing so will require patching the postgres source. Example commits and relevant code: - [Grammar entry point](https://github.com/postgres/postgres/blob/master/src/backend/parser/gram.y) - [kwlist.h](https://github.com/postgres/postgres/blob/master/src/include/parser/kwlist.h) - [MERGE implementation commit](https://github.com/postgres/postgres/commit/d204ef63776b8a00ca220adec23979091564e465) - [COPY statement](https://github.com/postgres/postgres/blob/b41669118c00e25376a6c9ac991e0d074990484a/src/backend/parser/gram.y#L2948-L3184) - [COPY logic](https://github.com/postgres/postgres/blob/5b0c7e2f757a2cbdd8e0c478de51bcb5606d3a93/src/backend/commands/copy.c)

jleclanche

It would be great to have a framework that we could test created functions against expected results. For example, testing ```sql SELECT getdate(); ``` would ensure that the added function...

shawnpyle

``` CREATE TABLE public.__yuniql_schema_version( sequence_id INT IDENTITY(1,1) PRIMARY KEY NOT NULL, version VARCHAR(512) NOT NULL, applied_on_utc TIMESTAMP NOT NULL DEFAULT(GETDATE()), applied_by_user VARCHAR(128) NOT NULL DEFAULT(CURRENT_USER), applied_by_tool VARCHAR(32) NOT NULL, applied_by_tool_version...

rdagumampan

json_extract_array_element_text for strings

2

Compare: `select json_extract_array_element_text('["Sandwich", "Omelette", "Tikka Masala"]', 0)` In Redshift, that gets you an unquoted `Sandwich`, in docker-pgredshift that gets you a double-quoted `"Sandwich"`. Adding `.strip('"')` to the `json.dumps` seems to...

mbrackett

Potentially drop unsupported functions, at least the documented ones. https://docs.aws.amazon.com/redshift/latest/dg/c_unsupported-postgresql-functions.html

jleclanche

Hi, thank you for pgredsfhit. I found some Docker build error, and fixed them. Please check it 🙏🏻

letusfly85