ruby on rails - Heroku Postgresql SET datestyle To european -

I am addressing an issue where I can not copy the data to the postgresql in the rail because date format default postgresql iso MDY

On my local machine, I have just converted Dietsticks to European so that my DMV data corresponds exactly.

As always, it's not easy to do this on the Heroku production server. Using the steps given below, I try to change the datestyle, which works but it is not released (as shown out, I am asked to go back and show the post style).

Any idea how I can continue this, all the research has not done this and to change the data to convert the data into MDY, but I am pulling millions of rows from a heritage system That omits as DMY and uses it to postgrescale copy command, it probably uses the fastest way to fix everything just post-playback to date stages It is easy to say:

  $ heroku pg: psql appname: CRIMSON = & gt; Settles for 'European'; SET AppName :: CRIMSON = & gt; Show Ditstyle; Date style ----------- ISO, DMY (1 line) AppName: Crimson- & gt; \ Q $ heroku pg: psql --- & gt; HEROKU_POSTGRESQL_CRIMSON_URL (DATABASE_URL) psql (9.4.1, server 9.3.6) Type "help" to help connect to a SSL connection (protocol: TLSv1.2, cipher: jabberish, bits: 256, compression: off) App name :: CRIMSON = & gt; Show Ditstyle; DateStyle ----------- ISO, MDY (1 line)  

< Blockquote>

Any ideas how I can continue this

Data Style is a server setting (in postgresql.conf) which can override client sessions ( set date style ... ) There are two ways to continue a change for a single transaction or one session beyond one session.

• Change the settings in postgraskey.cong and restart the server. (You do not have the privilege to edit PostGraceConf.conf, right?)
• ALTER DATABASE your_database_name set ISO, European '<' code> (Herako should work for you. I had set it as a stand-alone migration.)

FWIW, the default is not ISO MDY This is iso, MDY . (Two values, separated by commas.) The first is "Output Format Specification"; The second is "Input / Output Specification for Order of the Year / Month / Day" (see)