SELECT unnest(string_to_array(‘1,2,3,4’, ‘,’))
un string lo transformas a un array y el unnest te lo pone en filitas… bien tecnico
Saludos,
Datazo V
Related Posts
How To Install PostgreSQL With Docker Quickly
Many developers still install a database on their computer and work on it. It may be a preferable method, but using Docker takes only seconds […]
Postgres PSQL y la linea de comandos de Windows.
¿Quien no ha intentado usar postgres desde la linea de comandos de windows, tal cual lo haria con el osql de SQL Server? Por ejemplo: […]
entity-attribute-value design in PostgreSQL – don’t do it! – CYBERTEC
Customers have often asked me what I think of “Entity-attribute-value” (EAV) design. So I thought it would be a good idea to lay down my […]