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 *.*
| { | |
| "binary_file_patterns": | |
| [ | |
| "*.jpg", | |
| "*.jpeg", | |
| "*.png", | |
| "*.gif", | |
| "*.ttf", | |
| "*.tga", | |
| "*.dds", |
| + + | |
| `.....` | |
| `:#+;:,.,:;'##;. | |
| '#:``.```````````:#' | |
| '+,...````````````````'+ | |
| @:..````````````````````.#, | |
| .#,`````````````````````````@; | |
| `#.````` ` ````````@@, | |
| @.````` ```````+'@, |
| ,,########################################,, | |
| .*##############################################* | |
| ,*####*:::*########***::::::::**######:::*###########, | |
| .*####: *#####*. :*###,.#######*,####*. | |
| *####: *#####* .###########* ,####* | |
| .*####: ,#######, ##########* :####* | |
| *####. :#########*, ,,,,,,,,. ,####: | |
| ####* ,##############****************:,, .####* | |
| :####*#####################################**, *####. | |
| *############################################*, :####: |
| // (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; }, |
| // 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; |