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.