Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- psql -d myDataBase -a -f myInsertFile
- psql -d HIGHWAYS -a -f CLUSTER_1000M.sql
- # IPv6 local connections:
- host myDbName myUserName ::1/128 trust
- psql -U username -d myDataBase -a -f myInsertFile
- i path_to_sql_file
- export PGPASSWORD=<password>
- psql -h <host> -d <database> -U <user_name> -p <port> -a -w -f <file>.sql
- database-# >@pathof_mysqlfile.sql
- or
- database-#>-i pathof_mysqlfile.sql
- or
- database-#>-c pathof_mysqlfile.sql
- psql -h localhost -d userstoreis -U admin -p 5432 -a -q -f /home/jobs/Desktop/resources/postgresql.sql
- -h PostgreSQL server IP address
- -d database name
- -U user name
- -p port which PostgreSQL server is listening on
- -f path to SQL script
- psql --version
- which psql
- select * from mytable;
- psql -U pgadmin -d kurz_prod -a -f mysqlfile.sql
- select * from mytable;
- test1
- --------
- hi
- me too
- (2 rows)
- ../bin>psql -f c:/...-h localhost -p 5432 -d databasename -U "postgres"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement