Question : I’m in the middle of a database server migration and I can’t figure (after googling and searching here) […]
Tag: psql
How to execute multiple postgres script from command prompt
Question : I have 100 script files which has insert scripts for the table. How can I execute these? Scrip1.sql […]
How do I create a psql alias for “q”?
Question : I’m using Postgres 9.5 on Ubuntu 14.04. Even after using Postgres for a year, I can’t get used […]
Cannot start psql with user postgres “Could not change directory to /home/user ”
Question : I did a silly mistake. I wanted to set postgres permissions to a folder for exporting data from […]
Sql plus equivalent in psql
Question : I’m tasked of migrating some code from sqlplus to psql In oracle, I have a bash script that […]
How to turn off header only in psql (postgresql)
Question : I’m using PostgreSQL 9.1.X I am trying to build psql script to print results without a header but […]
How can I use `psql` without installing via brew
Question : I want to use the psql utility standalone, without installing postgress via brew or something (I have my […]
Wildcard for meta-command in postgresql
Question : I am searching if there is a wildcard assigned to the meta-commandsSee description – meta-commands in Postgresql. for […]
Can PostgreSQL results include the query?
Question : I run the following command to run 2 queries in a sql file. Could be 1, could be […]
How can I import an old pgdump into an updated schema?
Question : I’m DB newb doing a software upgrade, and my predecessor’s original migration plan may not have been as […]