This file contains 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
#!/bin/sh | |
# Written by: Keefer Rourke <https://krourke.org> | |
# Based on AUR package <https://aur.archlinux.org/cgit/aur.git/tree/PKGBUILD?h=ttf-google-fonts-git> | |
# dependancies: fonts-cantarell, ttf-ubuntu-font-family, git | |
sudo apt-get install fonts-cantarell ttf-ubuntu-font-family git | |
srcdir="/tmp/google-fonts" | |
pkgdir="/usr/share/fonts/truetype/google-fonts" | |
giturl="git://github.com/google/fonts.git" |
This file contains 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
psql -h hostname -U username -W -d database -t -A -F "," -c "SELECT * FROM table" > file.csv | |
# Explanation of the used options: | |
# -h Specifies the host name of the machine on which the server is running. | |
# -U Connect to the database as a specific user. | |
# -W Force psql to prompt for a password before connecting to a database. | |
# -d Specifies the name of the database to connect to. | |
# -t Turn off printing of column names and result row count footers, etc. | |
# -A Switches to unaligned output mode. | |
# -F Use separator as the field separator for unaligned output. |