Skip to main content
Database Administrators

Return to Answer

Made output path less linuxy
Source Link
Gary
Gary
  • 101
  • 4

Here is a Windows alternative to @Daniel Vérité's 9.3 answer

execute 'copy (select * from tableName) to PROGRAM ''findstr "^" >>/tmp/result c:\somePath\result.txt'''

I borrowed this findstr technique from this answer.

Here is a Windows alternative to @Daniel Vérité's 9.3 answer

execute 'copy (select * from tableName) to PROGRAM ''findstr "^" >>/tmp/result.txt'''

I borrowed this findstr technique from this answer.

Here is a Windows alternative to @Daniel Vérité's 9.3 answer

execute 'copy (select * from tableName) to PROGRAM ''findstr "^" >> c:\somePath\result.txt'''

I borrowed this findstr technique from this answer.

Source Link
Gary
Gary
  • 101
  • 4

Here is a Windows alternative to @Daniel Vérité's 9.3 answer

execute 'copy (select * from tableName) to PROGRAM ''findstr "^" >>/tmp/result.txt'''

I borrowed this findstr technique from this answer.