- #!/bin/expect
- set timeout 300
- set host [lindex $argv 0]
- set port [lindex $argv 1]
- set username [lindex $argv 2]
- set password [lindex $argv 3]
- set dbname [lindex $argv 4]
- set table [lindex $argv 5]
- set filename [lindex $argv 6]
- spawn psql -h ${host} -p ${port} -U ${username} -d ${dbname} -c "\\copy ${table} from ${filename} with csv"
- expect "Password" {
- send "${password}\r"
- }
- expect eof
|
