Export table from PostgreSQL

export_table.sh

#!/bin/sh

# Prepare names
DEFAULT_DB_NAME="my_web_admin"
read -p "Enter database name [$DEFAULT_DB_NAME]: " DB_NAME
DB_NAME=${name:-$DEFAULT_DB_NAME}
read -p "Enter table name in db '$DB_NAME' name to make schema dump: " TABLE_NAME
DIR_NAME="$DB_NAME"

# Exit if table name not writen
if [ "$TABLE_NAME" = "" ]; then
  echo "You loose (I need table name)"
  exit 
fi

mkdir $DIR_NAME
FILE_NAME="${DIR_NAME}/${TABLE_NAME}.sql"
echo "I will create a file called $FILE_NAME with data dump from ${TABLE_NAME}"

pg_dump -h localhost -U postgres -d $DB_NAME -t "\"$TABLE_NAME\"" > "$FILE_NAME"

echo "Done"