Arman Yessenamanov yesenarman
yesenarman
/ dotenv.bashrc
Created
February 15, 2023 20:12
Shell utility command to load .env files in current terminal session
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| dotenv () { | |
| [ -f "$1".env ] && export $(egrep -v "^#" "$1".env | xargs) || echo "dotenv: $1.env: No such file or directory" | |
| } |
yesenarman
/ export_csv.sql
Last active
February 7, 2023 11:14
Export CSV data from PostgreSQL table
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| COPY ( | |
| SELECT * FROM table | |
| ) | |
| TO STDOUT WITH (FORMAT CSV, HEADER TRUE, FORCE_QUOTE *) |