"merge" two tables -from different databases- together?

1 vote

1 answer

1343 views

                          Well say I have a table running on a database at localhost (donor database A), and a receiving table running at another server externally (database B) With table creation (on both sides) like:


    CREATE TABLE public.my_table (
        id integer NOT NULL,
        key text NOT NULL UNIQUE,
        description text,
        PRIMARY KEY (id)
    );
    
    
    CREATE SEQUENCE public.my_table_id_seq
        AS integer
        START WITH 1
        INCREMENT BY 1
        NO MINVALUE
        NO MAXVALUE
        CACHE 1;
    
    ALTER TABLE public.my_table ALTER COLUMN id SET DEFAULT nextval('public.language_dictionary_id_seq'::regclass)


Now I wish to merge from database A into database B. *However* only merging should happen on keys that are not existing on database B, and id should be recalculated (obviously to not have duplicates).

Basically as if each row from database A is insert into database B using:

    INSERT INTO public.my_table (key, description)
    VALUES (...)
    ON CONFLICT DO NOTHING
                        

Asked by paul23 (483 rep)

Jan 29, 2021, 01:48 PM
Last activity: Apr 23, 2025, 09:03 AM

"merge" two tables -from different databases- together?

Related Questions