gunzip -c filename.gz | psql -U user --dbname dbname