Skip to content

Instantly share code, notes, and snippets.

View carlosayam's full-sized avatar

Carlos Aya-Moreno carlosayam

View GitHub Profile
@carlosayam
carlosayam / gist:5316969
Last active January 4, 2022 03:30
Output branches description in Git (bash version)
#!/bin/bash
set -f
git branch | while read line; do
current=' '
name=${line##\* } ## removes leading * for current
if [ ! "$name" = "$line" ]; then current='* '; fi
description=`git config branch.$name.description`
echo "$current" $name : $description
done
@carlosayam
carlosayam / example.sql
Created May 16, 2018 21:07
best way to get csv output from postgresql in psql via \i example.sql
\set somevar1 '\'2018-01-01\''
\set somevar2 '\'2017-01-01\''
\echo Starting
\pset fieldsep ','
\pset format unaligned
\pset null '(null)'
\o 'your-output.csv'
-- here your query
select
field1, field2