From: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> |
---|---|
To: | <jm(at)poure(dot)com>, <mikew(at)hyperreal(dot)org> |
Cc: | <pgadmin-support(at)postgresql(dot)org>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: [GENERAL] pgAdmin vs SQL Server Enterprise Manager |
Date: | 2003-10-30 08:30:31 |
Message-ID: | 03AF4E498C591348A42FC93DEA9661B84C5C9D@mail.vale-housing.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support pgsql-general |
Hi Mike,
> -----Original Message-----
> From: Jean-Michel POURE [mailto:jm(at)poure(dot)com]
> Sent: 29 October 2003 18:32
> To: mikew(at)hyperreal(dot)org
> Cc: pgadmin-support(at)postgresql(dot)org; pgsql-general(at)postgresql(dot)org
> 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Matt Chatterley | 2003-10-30 10:07:48 | Re: Constraint Bug |
Previous Message | Michael Foy | 2003-10-29 21:12:23 | PGAdmin III - string literal parse error entering functions |
From | Date | Subject | |
---|---|---|---|
Next Message | Pedro Miguel Guedes | 2003-10-30 08:37:40 | help from Portugal |
Previous Message | Razvan Surdulescu | 2003-10-30 04:41:04 | INSERT performance |