I am having a hard time with this bulk copy syntax. Looks to me like I followed the correct syntax from a tutorial i checked out. But there seems to be a syntax error that i cannot detect. Need some help on this.
COPY aza_ods_version2.test2
FROM {'/Users/kevingitonga/Desktop/test1.csv' | STDIN}
[ [ WITH ]
[ BINARY ]
[ OIDS ]
[ DELIMITER [ AS ] ',' ]
[ CSV [ HEADER ]]
]at the end ? Here is one useful so link stackoverflow.com/questions/32271378/… and the official document postgresql.org/docs/9.1/….[and]should not be entered - they just document optional parameters. See the examples in the manual