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..