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

Reply via email to