On 11/11/2010 08:15 PM, Guillaume Lelarge wrote:
I would like to create a specific database on a another location (not in
"data_directory = '/var/lib/postgresql/8.3/main'" ). I was wondering if
I have to run
initdb -D /other/path/
of if there is another way
To create another database in anot
Le 11/11/2010 17:46, Vangelis Katsikaros a écrit :
> On 11/11/2010 03:05 PM, Guillaume Lelarge wrote:
>>
>> You should better look at pgloader which will use COPY to put your data
>> in your table and found the lines in error. Of course, it takes time to
>> detect lines in error. But at least, all
On 11/11/2010 03:05 PM, Guillaume Lelarge wrote:
You should better look at pgloader which will use COPY to put your data
in your table and found the lines in error. Of course, it takes time to
detect lines in error. But at least, all "good" lines will be in your
table, and all "bad" lines will b
On Thu, Nov 11, 2010 at 8:05 AM, Guillaume Lelarge
wrote:
> Le 11/11/2010 13:01, Vangelis Katsikaros a écrit :
>> Hello
>>
>> I have postrges 8.3.12 and I have the following issue:
>>
>> I have a table
>> create table test(
>> table_id integer,
>> datetime timestamp,
>> MMSI integer
Le 11/11/2010 13:01, Vangelis Katsikaros a écrit :
> Hello
>
> I have postrges 8.3.12 and I have the following issue:
>
> I have a table
> create table test(
> table_id integer,
> datetime timestamp,
> MMSI integer,
> lat real,
> lng real,
> );
>
> and I bulk insert data
Hello
I have postrges 8.3.12 and I have the following issue:
I have a table
create table test(
table_id integer,
datetime timestamp,
MMSI integer,
lat real,
lng real,
);
and I bulk insert data to this table with COPY.
A tiny portion of the data in the file are wrong. F
