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 *.*
xkraty
/ postgres-cheatsheet.md
Created
April 5, 2016 15:02
— forked from Kartones/postgres-cheatsheet.md
PostgreSQL command line cheatsheet
xkraty
/ gist:4257822
Created
December 11, 2012 11:08
— forked from doginthehat/gist:1890659
compare block helper for handlebars
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
| // (from http://doginthehat.com.au/2012/02/comparison-block-helper-for-handlebars-templates/) | |
| // Usage: {{#xIf a 'operator' b}} true {{else}} false {{/xIf}} | |
| Handlebars.registerHelper('xIf', function(lvalue, operator, rvalue, options) { | |
| if (arguments.length < 3) | |
| throw new Error("Handlerbars Helper 'compare' needs 3 parameters"); | |
| var operators = { | |
| '==': function(l,r) { return l == r; }, | |
| '===': function(l,r) { return l === r; }, | |
| '!=': function(l,r) { return l != r; }, |
xkraty
/ handlebars.object_helpers.js
Created
December 7, 2012 13:23
— forked from strathmeyer/handlebars.object_helpers.js
Handlebars.js helpers to iterate over objects
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
| // HELPER: #key_value | |
| // | |
| // Usage: {{#key_value obj}} Key: {{key}} // Value: {{value}} {{/key_value}} | |
| // | |
| // Iterate over an object, setting 'key' and 'value' for each property in | |
| // the object. | |
| Handlebars.registerHelper("key_value", function(obj, options) { | |
| var buffer = "", | |
| key; |