labkey-stuartm

PSQL

Magic words:

psql -U postgres

Some interesting flags (to see all, use -h or --help depending on your psql version):

-E: will describe the underlaying queries of the \ commands (cool for learning!)
-l: psql will list all databases and then exit (useful if the user you connect with doesn't has a default database, like at AWS RDS)

	#!/bin/bash
	#
	#########################################################################
	#This software code is made available "AS IS" without warranties of any #
	#kind. You may copy, display, modify and redistribute the software #
	#code either by itself or as incorporated into your code; provided that #
	#you do not remove any proprietary notices. Your use of this software #
	#code is at your own risk and you waive any claim against Amazon #
	#Digital Services, Inc. or its affiliates with respect to your use of #
	#this software code. (c) 2006-2007 Amazon Digital Services, Inc. or its #

	#!/bin/bash

	# You must accept the Oracle Binary Code License
	# http://www.oracle.com/technetwork/java/javase/terms/license/index.html
	#
	# @author 2014-2017 n0ts <[email protected]> (https://gist.github.com/n0ts/40dd9bd45578556f93e7)
	# @author 2018 niko <[email protected]> (https://gist.github.com/nikolauskrismer/d0818c3e27d18bc7a25e6c5c197f42c6)
	#
	# usage: get_oracle_jdk_linux_x64.sh <jdk_version> <ext>
	#

	#!/bin/bash

	DEVICE=/dev/$(lsblk -n \| awk '$NF != "/" {print $1}')
	FS_TYPE=$(file -s $DEVICE \| awk '{print $2}')
	MOUNT_POINT=/data

	# If no FS, then this output contains "data"
	if [ "$FS_TYPE" = "data" ]
	then
	echo "Creating file system on $DEVICE"

	from __future__ import print_function

	import json
	import boto3
	import logging

	#setup simple logging for INFO
	logger = logging.getLogger()
	logger.setLevel(logging.ERROR)