Skip to content

Instantly share code, notes, and snippets.

@Charmatzis

Charmatzis/psql_concat_uuid_with_single_quotes.sql

Last active February 10, 2022 11:11
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Charmatzis/50e383c1f4c6ee963488bd8b997e256c to your computer and use it in GitHub Desktop.
Save Charmatzis/50e383c1f4c6ee963488bd8b997e256c to your computer and use it in GitHub Desktop.
Download ZIP
concat UUID with single quotes in postgreSQL
Raw
psql_concat_uuid_with_single_quotes.sql
SELECT concat(concat('"', string_agg(uuid, '","')) , '"')
FROM (
SELECT uuid::text
FROM public.my_table
) a;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment