[GENERAL] Copy Data between different databases

2015-03-03 Thread Tim Semmelhaack
run a much simpler version of the query with the -c "Select .." option it works. Because the sql-scripts are quite long, I don't to do it without the -f option. So where is the difference between the -c and the -f option? Tim -- Semmelhaack(at)gmx(dot).de -- Sent via pgsql-

Re: [GENERAL] Copy Data between different databases

2015-03-05 Thread Tim Semmelhaack
] Gesendet: Mittwoch, 4. März 2015 15:48 An: Adrian Klaver Cc: Tim Semmelhaack; pgsql-general@postgresql.org Betreff: Re: [GENERAL] Copy Data between different databases Hi Adrian: On Wed, Mar 4, 2015 at 1:03 AM, Adrian Klaver mailto:adrian.kla...@aklaver.com> > wrote: ​As you pointed,

[GENERAL] Import German Number Format

2008-10-02 Thread Tim Semmelhaack
Hello, I have to import a huge number of data sets of data sets with "Copy from". The numbers are formatted with decimal comma ',' (as usual in Germany) instead of the decimal point '.' When I try to import this data Postgres crashes, so I think I have to change a parameter with SET? Does anybod