Re: Allow logical replication to copy tables in binary format - Mailing list pgsql-hackers

postgres=# \d temp
                        Table "public.temp"
 Column |           Type           | Collation | Nullable | Default
--------+--------------------------+-----------+----------+---------
 i      | integer                  |           |          |
 b      | bytea                    |           |          |
 t      | timestamp with time zone |           |          |

postgres=# SELECT pg_size_pretty( pg_total_relation_size('temp') );
 pg_size_pretty
----------------
 1137 MB
(1 row)

CREATE OR REPLACE PROCEDURE wait_for_rep() LANGUAGE plpgsql AS $$BEGIN WHILE (SELECT count(*) != 0 FROM pg_subscription_rel WHERE srsubstate <> 'r') LOOP COMMIT; END LOOP; END; $$;