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 open them and copy the INSERT statements into an editor window and run them there.


You can use the following by navigating to the bin folder of your PostgreSQL install:

psql -U username -d myDataBase -a -f myInsertFile


You have four choices to supply a password: 

Commenti

Post popolari in questo blog

Solaris 10: How to restart network service without reboot

How to send e-mail using PHP and mail() with Linux Debian