Re: COPY enhancements
От | Pierre Frédéric Caillaud |
---|---|
Тема | Re: COPY enhancements |
Дата | |
Msg-id | op.uz3msqm9cke6l8@soyouz обсуждение исходный текст |
Ответ на | Re: COPY enhancements (Robert Haas <robertmhaas@gmail.com>) |
Ответы |
Re: COPY enhancements
|
Список | pgsql-hackers |
> 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 ?...
В списке pgsql-hackers по дате отправления: