Boston Linux & Unix (BLU) Home | Calendar | Mail Lists | List Archives | Desktop SIG | Hardware Hacking SIG
Wiki | Flickr | PicasaWeb | Video | Maps & Directions | Installfests | Keysignings
Linux Cafe | Meeting Notes | Linux Links | Bling | About BLU

BLU Discuss list archive


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

Re: Why is Postgres so much better than MySQL?



 On Mon, Jan 14, 2008 at 08:13:52AM -0500, David Kramer wrote: 
> I did have a win for MySQL over Postgres last week, though.  We had to 
> move a Postgres databases to (gasp) SQL Server (the government site it's 
> going into is MSFT-only).  I'm used to looking at MySQL dumps, and thye 
> look pretty much like straight SQL (to the extent that schema operations 
> are part of the standard, which is "not much").  But this Postgres dump 
> was a ponderous looking beast with COPY commands and all sorts of things 
> that looked nothing like SQL we could convert to something SQLServer 
> could use. 

Uhm - use pg_dump with the --inserts option ?! 

Thanks, 
Ward. 

-- 
Pong.be         -(   "Those who do not understand Unix are condemned to    )- 
Virtual hosting -(         reinvent it, poorly." -- Henry Spencer          )- 
http://pong.be  -(                                                         )- 
GnuPG public key: http://pgp.mit.edu

-- 
This message has been scanned for viruses and 
dangerous content by MailScanner, and is 
believed to be clean. 

_______________________________________________ 
Discuss mailing list 
[hidden email] 
http://lists.blu.org/mailman/listinfo/discuss
 


BLU is a member of BostonUserGroups
BLU is a member of BostonUserGroups
We also thank MIT for the use of their facilities.

Valid HTML 4.01! Valid CSS!



Boston Linux & Unix / webmaster@blu.org