Shell script for exporting all tables for any given postgresql database_name

psql_table_exporter.sh

#!/bin/bash

# exports separate sql files for each table in the db. excludes "pg_" and "sql_" prefixed tables
for table in $(psql database_name -t -c "Select table_name From information_schema.tables Where table_type='BASE TABLE' and table_name not like 'pg_%' and table_name not like 'sql_%'");
do pg_dump -t $table database_name > /path/to/export/your/tables/$table.sql;
done;