Ramesh T wrote > Hi, > I have deletion script to delete particular cust from > database.I was > saved a file name with custde.sql.i need to run from command line like > putty tool..But have a problem > > example : > > delete from part where part.custid=$1; > > when i ran custde.sql from putty tool > > db=#\i custde.sql > > it's return error > psql:custde.sql:9: ERROR: there is no parameter $1 > LINE 1: ..._ID from part where part.CUST_ID = $1); > > please let me know how to run script ..and how to give parameter..
psql doesn't use parameters - it uses variables. http://www.postgresql.org/docs/9.3/interactive/app-psql.html In part <and not tested>: echo "DELETE FROM part WHERE part.CUST_ID = :'del_id';" > custde.sql psql --set=del_id=383373 --file=custde.sql Note that based on your prompt (db=#) and the command "\i" you are already using psql interactively. This not the same thing as "I need to run from command line like putty tool". Beyond this you need to learn about shell scripting to more readily integrate psql into a complex process. David J. -- View this message in context: http://postgresql.1045698.n5.nabble.com/Deletion-tp5816588p5816617.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
