dbaspot
Tags Register FAQ Calendar Search Today's Posts Mark Forums Read

Psql Copy statement with Parameter variable - postgresql

This is a discussion on Psql Copy statement with Parameter variable - postgresql ; psql -c "copy sometable from _filename WITH HEADER CSV;" -e -t -v p_filename=$CSV_FILE -h xx.xx.xx.xx -p 54444 -U someuser dbname=somedb this raise an error on shell script "Syntax error at or near ":" Can anyone suggest alternate solutions here? Thanks...


Home > Database Forum > Other Databases > postgresql > Psql Copy statement with Parameter variable

Reply

 

LinkBack Thread Tools Display Modes
  #1  
Old 09-01-2009, 05:15 AM
Database Newbie
  
Join Date: Sep 2009
Posts: 2
nutcrackers is on a distinguished road
Default Psql Copy statement with Parameter variable
psql -c "copy sometable from _filename WITH HEADER CSV;" -e -t -v p_filename=$CSV_FILE -h xx.xx.xx.xx -p 54444 -U someuser dbname=somedb

this raise an error on shell script "Syntax error at or near ":"

Can anyone suggest alternate solutions here?

Thanks
Reply With Quote
Reply

Tags
copy, parameter, psql, scripts, shell

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Linear Mode Linear Mode


Similar Threads

Thread Thread Starter Forum Replies Last Post
Procedure Cache and Statement Cache (reported in sysmon) Database Administrator sybase 11 08-20-2008 09:17 AM
Set SQL Parameter from Variable - Matteus Help Database Administrator ms-sqlserver 8 08-05-2008 06:40 AM
Problems with variable passing and databasemail tasks Database Administrator ms-sqlserver 1 05-29-2008 07:23 PM
Problem with Scheduler in Xilkernel. Database Administrator Arch 4 05-21-2008 02:56 AM
MySQL 5.0.51 has been released Database Administrator mysql 0 12-06-2007 02:40 PM


All times are GMT -4. The time now is 11:44 PM.