How to print current working directory in psql console?

postgresql psql
Don P picture Don P · Jul 13, 2017 · Viewed 16.1k times · Source

I am trying to restore a schema on a remote server using the psql console in pgAdmin and an sql dump file. I receive the following error: 

user=> \i file.sql
file.sql: No such file or directory

I can't seem to print the directory listings due to lacking superuser privileges.

Is there a way to identify or print the current working directory in psql console? What is the default directory?

Answer

vipulsinghthakur picture vipulsinghthakur · May 10, 2018

Typing in the command \! pwd will print the current working directory in psql. To change working directory use command \cd <path>; replace <path> with desired path. Eg. Running command \cd /run/mount will change the current working directory to /run/mount. Try changing the your working directory to that containing the file which you want to run and then use \i meta command as you did earlier. It will definitely work.

Related questions

PostgreSQL "DESCRIBE TABLE"

How do you perform the equivalent of Oracle's DESCRIBE TABLE in PostgreSQL (using the psql command)?

Read More
Run a PostgreSQL .sql file using command line arguments

I have some .sql files with thousands of INSERT statements in them and need to run these inserts on my PostgreSQL database in order to add them to a table. The files are that large that it is impossible to …

Read More
How to switch databases in psql?

In MySQL, I used use database_name; What's the psql equivalent?

Read More