Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Zero-ETL support for PostgreSQL #119

Closed
2 tasks done
TianyuZhang1214 opened this issue Nov 6, 2024 · 0 comments
Closed
2 tasks done

Zero-ETL support for PostgreSQL #119

TianyuZhang1214 opened this issue Nov 6, 2024 · 0 comments
Assignees

Comments

@TianyuZhang1214
Copy link
Contributor

TianyuZhang1214 commented Nov 6, 2024

-- All SQLs need to be executed one by one.

INSTALL postgres_scanner;
LOAD postgres_scanner;
ATTACH 'dbname=postgres user=postgres password=root host=127.0.0.1 port=15432' AS pg_postgres (TYPE POSTGRES);

BEGIN;
COPY FROM DATABASE pg_postgres TO postgres;
--  store the result into a variable of code(go, shell).
SELECT * FROM postgres_query('pg_postgres', 'SELECT pg_current_wal_lsn()');
COMMIT;
TianyuZhang1214 added a commit that referenced this issue Nov 19, 2024
TianyuZhang1214 added a commit that referenced this issue Nov 19, 2024
@TianyuZhang1214 TianyuZhang1214 linked a pull request Nov 22, 2024 that will close this issue
TianyuZhang1214 added a commit that referenced this issue Nov 22, 2024
TianyuZhang1214 added a commit that referenced this issue Nov 22, 2024
TianyuZhang1214 added a commit that referenced this issue Nov 22, 2024
TianyuZhang1214 added a commit that referenced this issue Nov 25, 2024
TianyuZhang1214 added a commit that referenced this issue Nov 26, 2024
TianyuZhang1214 added a commit that referenced this issue Nov 26, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants