command line postgres

bin>psql -U postgres
Password for user postgres: super

postgres=# \c gospay enter

postgres=# \connect gospay enter

udah masuk ke data

gospay=#

untuk insert data nya

1.Be careful with "/" and "\". Even on Windows the command should be in the form:

\i c:/1.sql

url

http://stackoverflow.com/questions/3393961/how-to-import-existing-sql-files-in-postgresql-8-4 

2. 

139down vote

Of course, you will get fatal error for authenticating because you do not include user name.. try this one, It is ok for me :) psql -U username -d myDataBase -a -f myInsertFile

url nya : 

http://stackoverflow.com/questions/9736085/run-a-postgresql-sql-file-using-command-line-args

Tweet