Hi Mike, > -----Original Message----- > From: Jean-Michel POURE [mailto:[EMAIL PROTECTED] > Sent: 29 October 2003 18:32 > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: Re: [pgadmin-support] [GENERAL] pgAdmin vs SQL > Server Enterprise Manager > > > I am working at a company that has been using MS SQL Server, and we > > are going to be switching over to postgresql next week. > (Getting off > > of Windows will be a relief!)
:-) > > 1) With SQL Server Enterprise Manager, I can change a > column's type. > > For example, I can change an int column to a float, and SQL Server > > automatically converts all of the int data to floating point data. Unfortunately changing column types is not yet supported by PostgreSQL, though I believe one of the hackers (Rod Taylor) is working on it. Once PostgreSQL can do the job, we will of course add support in pgAdmin. > > 2) With SQL Server Enterprise Manager, I can copy and paste rows. > > There are two scenarios: Yes, I find that feature of EM very handy as well, both for creating new rows and copying data from one table/database to another. I have added this to the todo list. Good luck with your migration! Regards, Dave. ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
