I'm writing a batch script, and batch doesn't like |, heck nor does command line entries. The only way I can input this command is to initiate a psql login directly and then issue it, which ruins the intent of automating it.

echo COPY nSymbols(symbol,securityName,MarketCategory,testIssue,financialStatus,roundLotSize,nextShares) FROM 'c:\test\nasdaqSymbols.txt' DELIMITER '|' CSV HEADER;| psql -U postgres nasdaqsymbols

error I receive. Text data is pipe deliminated because the source text fields have commas.

''' is not recognized as an internal or external command, operable program or batch file.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.