Skip to content

Instantly share code, notes, and snippets.

@logbasex

logbasex/postgresql-note.sql

Last active May 15, 2020 04:49
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 logbasex/3f8bfec293def1f6b18bd7c9b681af7f to your computer and use it in GitHub Desktop.
Save logbasex/3f8bfec293def1f6b18bd7c9b681af7f to your computer and use it in GitHub Desktop.
Download ZIP
Raw
postgresql-note.sql
## Regex: https://www.postgresql.org/docs/9.3/functions-matching.html
` select url, thumbnail from media WHERE url !~* '.jpg|.mp4|.mov|.jpeg|.png|.mp3';`
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment