Kysely•13mo ago

Transform Postgres array into JS array

Hey, I was wondering if there's a helper or something to transform Postgres arrays {one, two} into JS arrays ['one', 'two']. Right I know the Postgres array is turned into a string when executing queries

Solution:

Message Not Public

Jump to solution

13 Replies

Unknown User•13mo ago

Message Not Public

Daniel Cruz•13mo ago

I'm getting a string. Maybe is the fact that my column type is an enum array?

Unknown User•13mo ago

Message Not Public

Daniel Cruz•13mo ago

Unknown User•13mo ago

Message Not Public

Daniel Cruz•13mo ago

Seems I have to add a parser https://github.com/brianc/node-pg-types/issues/56#issuecomment-323223477

GitHub

ENUM ARRAY types get parsed as single string · Issue #56 · brianc/n...

Hi, I found that currently there is an issue with the way pg-types parses ENUM ARRAY column types. Currently the array is not parsed at all and a simple string is returned with the SQL array serial...

Daniel Cruz•13mo ago

do you know how can I define the custom types with Kysely? 😅

Unknown User•13mo ago

Message Not Public

Daniel Cruz•13mo ago

Yep, I ended up doing

...
.selectAll("Collection")
.select((eb) => [
  sql<string[]>`categories::text[]`.as("categories"),
...

...
.selectAll("Collection")
.select((eb) => [
  sql<string[]>`categories::text[]`.as("categories"),
...

As using oid seems brittle, for any reason the id could change between dev and prod

koskimas•13mo ago

As using oid seems brittle, for any reason the id could change between dev and prod

You mean the data type oid in setTypeParser? ~~It won't change~~ Actually with custom types, I'm not so sure

Daniel Cruz•13mo ago

Yeah, the custom type oid was different in my local db and prod db, idk why 🤷‍♂️ but better not to risk it

Igal•13mo ago

This can be more type-safe:

.select((eb) => sql<string[]>`${eb.ref('categories')}::text[]`.as('categories'))

.select((eb) => sql<string[]>`${eb.ref('categories')}::text[]`.as('categories'))

Daniel Cruz•13mo ago

You're the best

Gaming

Programming

Transform Postgres array into JS array