Insert an array in postgresql database using vercel sql utility

Question

  import { sql } from '@vercel/postgres';
  const aliases= ['uncle', 'joe'];
  await sql`INSERT INTO USER (aliases) VALUES ${aliases}`;

USER would be defined like this

CREATE TABLE USER ( aliases text[]);

This code would give me an error : Argument of type 'string[]' is not assignable to parameter of type 'Primitive'.

Mr Day2Day · Accepted Answer · 2024-01-25 18:18:13Z

1

You can stringify the array before making the insert, eg: const aliases = JSON.stringify([...]) then when you read simply parse the string const parseData = JSON.parse(aliases)

answered Jan 25, 2024 at 18:18

Mr Day2Day

912 silver badges7 bronze badges

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

2 Comments

Anis Smail Over a year ago

I just added replace like this JSON.stringify(aliases).replace("[", "{").replace("]", "}") and it worked. Can you update your answer so I can accept it plz ?

FlowRan Feb 4 at 14:39

This solution adds a string, not an array. Is there any way to add an array since arrays are part of the Primitive types ?

Collectives™ on Stack Overflow

Insert an array in postgresql database using vercel sql utility

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related