#!/bin/bash

#export PGPASSWORD=
#export PGHOST=
#export PGPORT=
#export PGUSER=
#export PGDATABASE=

SCHEMA="$1"
TABLE="$2"

echo  "CREATE TABLE ${SCHEMA}.${TABLE} ("
psql -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 -n ")"
SORTKEY=$(psql -t -c "select \"column\" from pg_table_def where schemaname='$SCHEMA' and tablename = '$TABLE' and sortkey > 0 order by sortkey" |  tr "\n" "," | sed 's/\([,]*\)$//')
[ -n "$SORTKEY" ] && echo -n  " sortkey ($SORTKEY)"
DESTKEY=$(psql -t -c "select \"column\" from pg_table_def where schemaname='$SCHEMA' and tablename = '$TABLE' and distkey = true" |  tr "\n" "," | sed 's/\([,]*\)$//')
[ -n "$DESTKEY" ] && echo -n  " distkey ($DESTKEY)"
echo ";"