Thanks for the replies, I'm using postgres since 8.3 and didn't notice at
the time of 9.0 release the change in the syntax, as the old syntax still
works, every time I read the current documentation I didn't notice that I
was using it wrong.
I agree with Tom Lane about leaving it alone.
Another q
I don't understand exactly what are your problem.
In the beginning of your email, you said that you want to convert a text to
timestamp, which can be done like this:
select 'Tue Sep 24 08:56:18 + 2013'::timestamp
-- 2013-09-24 08:56:18
What you refer as "meaningless parts" are day of week an
4, date_column5 encoding 'latin1';
COPY 9
In the docs (http://www.postgresql.org/docs/current/static/sql-copy.html)
the "FORCE" options are written with "_" but the correct name is with " "
2016-04-28 17:27 GMT-03:00 Kevin Grittner :
> On Thu, Apr 28
Hi everyone,
In the documentation of COPY options, it lists the following options with a
"_" in it's name:
FORCE_QUOTE
FORCE_NOT_NULL
FORCE_NULL
But when one tries to use it as it is from the docs, one gets the following
results:
ERROR: syntax error at or near "force_null"
Shouldn't it be with
