verfriemelt-dot-org

#!/bin/bash

set -o errexit
set -o nounset
set -o pipefail
# set -o xtrace

trim_origin=false
include_local_branches=true
refs=()

verfriemelt-dot-org

psqlrc:

• some infos at initial connect
• predefined queries in ~/.psqlrc-include/ compiled by the _update.sh script into ~/.psqlrc-commands.sql which will be included within .psqlrc

typical worksetup:

• portforwarding from remote to local host via ssh user@host -L 5432:127.0.0.1:5432

verfriemelt-dot-org

DROP TABLE IF EXISTS  test CASCADE;  
DROP FUNCTION IF EXISTS test2;

CREATE TABLE test (
	a   INTEGER NOT NULL,
	b   INTEGER NOT NULL
);


CREATE OR REPLACE FUNCTION test2() RETURNS TRIGGER AS $$

verfriemelt-dot-org

[
	{ "keys": ["ctrl+shift+t"], "command": "toggle_comment", "args": { "block": false } },
	{ "keys": ["alt+shift+up"], "command": "swap_line_up" },
	{ "keys": ["alt+shift+down"], "command": "swap_line_down" },
	{ "keys": ["ctrl+shift+down"], "command": "duplicate_line" },
]