| 1 |
CREATE EXTENSION test_copy_callbacks; |
| 2 |
CREATE TABLE public.test (a INT, b INT, c INT); |
| 3 |
INSERT INTO public.test VALUES (1, 2, 3), (12, 34, 56), (123, 456, 789); |
| 4 |
SELECT test_copy_to_callback('public.test'::pg_catalog.regclass); |
| 5 |
NOTICE: COPY TO callback called with data "1 2 3" and length 5 |
| 6 |
NOTICE: COPY TO callback called with data "12 34 56" and length 8 |
| 7 |
NOTICE: COPY TO callback called with data "123 456 789" and length 11 |
| 8 |
NOTICE: COPY TO callback has processed 3 rows |
| 9 |
test_copy_to_callback |
| 10 |
----------------------- |
| 11 |
|
| 12 |
(1 row) |
| 13 |
|