Advertisement
Guest User

Untitled

a guest
Dec 27th, 2016
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.93 KB | None | 0 0
  1. psql -d myDataBase -a -f myInsertFile
  2.  
  3. psql -d HIGHWAYS -a -f CLUSTER_1000M.sql
  4.  
  5. # IPv6 local connections:
  6. host myDbName myUserName ::1/128 trust
  7.  
  8. psql -U username -d myDataBase -a -f myInsertFile
  9.  
  10. i path_to_sql_file
  11.  
  12. export PGPASSWORD=<password>
  13. psql -h <host> -d <database> -U <user_name> -p <port> -a -w -f <file>.sql
  14.  
  15. database-# >@pathof_mysqlfile.sql
  16. or
  17. database-#>-i pathof_mysqlfile.sql
  18. or
  19. database-#>-c pathof_mysqlfile.sql
  20.  
  21. psql -h localhost -d userstoreis -U admin -p 5432 -a -q -f /home/jobs/Desktop/resources/postgresql.sql
  22.  
  23. -h PostgreSQL server IP address
  24. -d database name
  25. -U user name
  26. -p port which PostgreSQL server is listening on
  27. -f path to SQL script
  28.  
  29. psql --version
  30. which psql
  31.  
  32. select * from mytable;
  33.  
  34. psql -U pgadmin -d kurz_prod -a -f mysqlfile.sql
  35.  
  36. select * from mytable;
  37.  
  38. test1
  39. --------
  40. hi
  41. me too
  42.  
  43. (2 rows)
  44.  
  45. ../bin>psql -f c:/...-h localhost -p 5432 -d databasename -U "postgres"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement