Re: dump to pg

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Nicolas Paris <niparisco(at)gmail(dot)com>
Cc: Forums postgresql <pgsql-general(at)postgresql(dot)org>
Subject: Re: dump to pg
Date: 2017-05-31 15:27:28
Message-ID: CAKFQuwYbudaVO1FprkpK8A0MvJ7=USsgY17a9tLvmOLVRbXk2g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, May 31, 2017 at 7:43 AM, Nicolas Paris <niparisco(at)gmail(dot)com> wrote:

> Hi,
>
> I have dumps from oracle and microsoft sql server (no more details). Is it
> possible to load them "directly" into postgres (without oracle/mssql
> license)?
> dump -> csv -> postgtres
> or something ?
>
>
​Asking the public mailing lists for PostgreSQL for an opinion on the the
legality of doing something like this is problematic​..

Technically it would depend a lot on exactly what you are trying to load.
If you can go through CSV to do it then its probably just raw insert data
and has a decent chance of working as long as the schema is PostgreSQL has
been created to accept the incoming data.

David J.

In response to

  • dump to pg at 2017-05-31 14:43:54 from Nicolas Paris

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rob Sargent 2017-05-31 15:33:10 Re: dump to pg
Previous Message Nicolas Paris 2017-05-31 14:43:54 dump to pg