I was thinking something like: COPY tablename [ ( column [, ...] ) ] FROM { 'filename' | STDIN } [WITH] [option [, ...]]Where: option := ColId [Sconst] | FORCE NOT NULL (column [,...]) I don't see any reasonable way to sandwhich the FORCE NOT NULL syntax into a keyword/value notation.
Postgres has a hstore data type which seems well suited for passing key/value option pairs... Why another syntax to remember, another parser to code, when almost everything is already there ?
Think about plpgsql code which generates some SQL COPY command string, then this is parsed and executed... wouldn't it be a lot simpler to just manipulate parameters in a hstore ?...
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
