David Tonhofer <bughunt(at)gluino(dot)name> writes:
> the syntax for the \copy command is given as follows:
> \copy { table [ ( column_list ) ] | ( query ) } { from | to } {
> 'filename' | program 'command' | stdin | stdout | pstdin | pstdout } [ [
> with ] ( option [, ...] ) ]
Yeah ...
> According to the description as given, the following should work.
> \copy table_to_fill from 'foofile.csv' with format csv, header true,
> delimiter ',';
Not sure how you get from the first to the second. The syntax clearly
shows parens around the option list as required.
regards, tom lane