How to properly use dblink_build_sql_insert (postgreSQL)

Question

I cannot find an example of how it's supposed to work for a table with only one PK field.

My attempt looks something like this:

CREATE EXTENSION IF NOT EXISTS dblink;

select dblink_build_sql_insert('table_name'::text, '1'::int2vector, 1::int2, '{"12345"}'::text[], '{"column1", "column2", "column3", "column4"}'::text[]);

It keeps trowing the error "target key array length must match number of key attributes". As I see it I told him that the number of key attributes is 1 and the target key array length has 1 item. What am I doing wrong?

Chris Travers · Accepted Answer · 2013-04-23 12:09:28Z

1

If I read the examples right, I think you need to do something like

select dblink_build_sql_insert(
     'table_name'::text, 
     '1'::int2vector, 
      1::int2,  -- num of pkey values
      '{"12345"}'::text[], -- old pkey 
     '{"column1"}'::text[] -- new pkey
);

answered Apr 23, 2013 at 12:09

Chris Travers

26.6k6 gold badges70 silver badges191 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to properly use dblink_build_sql_insert (postgreSQL)

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related