Postgresql

Buscar una palabra en cualquier parte de un campo

modelo = "(?=.*TEXTO_A_BUSCAR.*)"
select * from vehicle where marca ilike :marca and upper (modelo) ~ :modelo

Convertir un array de json en filas

select id, name, search_for_type from table,
                          jsonb_to_recordset(table.campojson) as items(name text,
                          search_for_type text)
where name='Data Lookup'

Comandos bash

ls -lhat

sudo find -name target -type d -exec rm -rf '{}' \;


Older post are available in the archive

2019 - 2021 | Mixed with Bootstrap | Baked with JBake v2.6.7