Alban Perillat-Merceroz A21z
smintz
/ SHOW CREATE TABLE REDSHIFT
Last active
November 11, 2020 08:27
This file contains 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
| #!/bin/bash | |
| SOURCEINSTANCE=${SOURCEINSTANCE:-''} | |
| SOURCEUSER=${SOURCEUSER:-'admin'} | |
| SOURCEPORT=${SOURCEPORT:-'5439'} | |
| SOURCEDB=${SOURCEDB:-'db'} | |
| SOURCESCHEMA=${SOURCESCHEMA:-'public'} | |
| SCHEMA=${SCHEMA:-'public'} | |
| echo "CREATE TABLE ${SCHEMA}.${TABLE} (" | |
| psql -h ${SOURCEINSTANCE} -U ${SOURCEUSER} -p ${SOURCEPORT} ${SOURCEDB} -t -c "select (\"column\" || ' ' || type || ' ENCODE ' || encoding || ',' ) from pg_table_def where schemaname='$SCHEMA' and tablename = '$TABLE'" | sed 's/ENCODE none/ENCODE RAW/' | sed '$d' | sed '$ s/,$//' | |
| echo ")" |
brandonb927
/ osx-for-hackers.sh
Last active
May 14, 2024 18:00
OSX for Hackers: Yosemite/El Capitan Edition. This script tries not to be *too* opinionated and any major changes to your system require a prompt. You've been warned.
This file contains 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
| #!/bin/sh | |
| ### | |
| # SOME COMMANDS WILL NOT WORK ON macOS (Sierra or newer) | |
| # For Sierra or newer, see https://github.com/mathiasbynens/dotfiles/blob/master/.macos | |
| ### | |
| # Alot of these configs have been taken from the various places | |
| # on the web, most from here | |
| # https://github.com/mathiasbynens/dotfiles/blob/5b3c8418ed42d93af2e647dc9d122f25cc034871/.osx |