MS SQL -> PostgreSQL: COPY command

Martijn van Oosterhout kleptog at svana.org
Wed Oct 16 14:18:41 EST 2002


On Wed, Oct 16, 2002 at 01:27:05PM +1000, Terence Kearns wrote:
> To be fair, it looks like they are planning to address most of the 
> serious deficiences for industrial strength capabilities.
> see. http://www.mysql.com/products/mysql-4.0/index.html

It's always over the horizon as far as I can tell.

> these changes are still in beta (have been for a few years now if I'm 
> not mistaken).
> 
> And, there are some nice features that not many other databases have. As 
> far as I know, you can't do joins across databases in postgres (without 
> using system tables?).

Well, you now have dblink() which can access tables remotely. Also, schemas
remove most of the reasons for multiple databases anyway.

> Terence Kearns wrote:
> 
> >
> >To be perfectly honest, I can't for the life of me understand this 
> >obsession with mysql when you have postgres... anyway, it's not 
> >productive to start a debate on that again.
> >
> 

-- 
Martijn van Oosterhout   <kleptog at svana.org>   http://svana.org/kleptog/
> There are 10 kinds of people in the world, those that can do binary
> arithmetic and those that can't.



More information about the linux mailing list