Magic words:
psql -U postgresIf run with -E flag, it will describe the underlaying queries of the \ commands (cool for learning!).
Most \d commands support additional param of __schema__.name__ and accept wildcards like *.*
Leondegwa
Leondegwa
/ pdf-report.py
Created
May 30, 2017 10:48
— forked from chris1610/pdf-report.py
PDF Report Generation - pbpython.com
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
| """ | |
| Generate PDF reports from data included in several Pandas DataFrames | |
| From pbpython.com | |
| """ | |
| from __future__ import print_function | |
| import pandas as pd | |
| import numpy as np | |
| import argparse | |
| from jinja2 import Environment, FileSystemLoader | |
| from weasyprint import HTML |
Leondegwa
/ gist:7db4b59cb7800e1222275f149b2e6725
Created
October 3, 2016 11:55
— forked from pitch-gist/gist:2999707
HTML: Simple Maintenance Page
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
| <!doctype html> | |
| <title>Site Maintenance</title> | |
| <style> | |
| body { text-align: center; padding: 150px; } | |
| h1 { font-size: 50px; } | |
| body { font: 20px Helvetica, sans-serif; color: #333; } | |
| article { display: block; text-align: left; width: 650px; margin: 0 auto; } | |
| a { color: #dc8100; text-decoration: none; } | |
| a:hover { color: #333; text-decoration: none; } | |
| </style> |
Leondegwa
/ postgres-cheatsheet.md
Created
September 27, 2016 15:55
— forked from Kartones/postgres-cheatsheet.md
PostgreSQL command line cheatsheet