Search Postgresql Archives

Re: dump to pg

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



> On May 31, 2017, at 9:27 AM, David G. Johnston <david.g.johnston@xxxxxxxxx> wrote:
> 
> On Wed, May 31, 2017 at 7:43 AM, Nicolas Paris <niparisco@xxxxxxxxx> 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.
> 
If the dumps are not ascii the ‘to csv’ step gets problematic if not impossible legally.




-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux