Re: BUG #15206: Can not import CSV into PostgreSQL

2018-05-20 11:36 GMT+02:00 Milorad Krstevski <miloradkrstevski(at)gmail(dot)com>:

> Thank you for all the prompt replies and explanations about databases. I
> am a little new in this, so maybe I made some conclusions not quite right.
>
> I was hoping that you can help me with issues like importing sql dumps
> from other sources (mssql and mysql), because I wanna migrate into postgre,
> and also how to import DDL from other tables into postgre and afterwards
> import the CSV files. Having them created manually is quite long.
>

Ora2pg supports migration from mysql too now.

https://github.com/darold/ora2pg

Regards

Pavel Stehule

>
> ---
> Milorad Krstevski
> M: +389 71 381 168
> E: miloradkrstevski(at)gmail(dot)com
>
> On Sun, May 20, 2018, 10:15 Peter J. Holzer <hjp-pgsql(at)hjp(dot)at> wrote:
>
>> On 2018-05-19 17:05:42 +0200, Milorad Krstevski wrote:
>> > So first I have to create all (for example 50 columns and define them
>> in data
>> > type) and then import? That is not the case with any other db.
>>
>> I am quite certain that it is also the case for Oracle and MySQL.
>>
>> I suspect that it is true for all SQL databases, since SQL distinguishes
>> between data definition (DDL) and data manipulation (DML) statements.
>> Loading data into a table is data manipulation, and you don't want that
>> to change your data definition as a side effect.
>>
>> Which database can automatically create columns while loading a CSV file
>> into a table?
>>
>> (It is of course possible to write a program which guesses the types of
>> the columns from the contents of the CSV file and then issues an
>> appropriate CREATE TABLE or ALTER TABLE statement. I wrote one 20 years
>> ago. But that's an application program, not part of the database.)
>>
>> hp
>>
>>
>> --
>> _ | Peter J. Holzer | we build much bigger, better disasters now
>> |_|_) | | because we have much more sophisticated
>> | | | hjp(at)hjp(dot)at | management tools.
>> __/ | http://www.hjp.at/ | -- Ross Anderson <https://www.edge.org/>
>>
>