Skip to content

Instantly share code, notes, and snippets.

@tbmreza

tbmreza/tricks

Last active October 6, 2024 23:02
Show Gist options
  • Save tbmreza/d5aa53ca18e5bdd228c60c043ad23ead to your computer and use it in GitHub Desktop.
Save tbmreza/d5aa53ca18e5bdd228c60c043ad23ead to your computer and use it in GitHub Desktop.
Download ZIP
unsorted snippets
Raw
tricks
load .env inline:
env $(cat .env | xargs) mix release
sqlite ls tables:
SELECT table_name FROM information_schema.tables WHERE table_schema = 'public’;
SELECT * FROM sqlite_master where type='table'; -- d1 ok
PRAGMA table_info(table_name);
postgres ls tables:
SELECT * FROM pg_catalog.pg_tables WHERE schemaname='public';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment