472,799 Members | 1,658 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,799 software developers and data experts.

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!)

I am very familiar with SQL Server's "Enterprise Manager", which is their GUI for accessing the db. I have been acquainting myself with pgAdmin. There are a number of things that I really like about pgAdmin, but there are a few things that SQL Server Enterprise manager can do, and it's not clear to me if pgAdmin can do them.

Can anyone let me know how the following things are done in the postgres world?
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.

2) With SQL Server Enterprise Manager, I can copy and paste rows. There are two scenarios:

2a) Suppose I have a table that has some primary key, and it has a large number of non-null columns. Inserting a row can be tedious because I have to specify all the non-null values. What I often want to do is to duplicate a row, change its primary key, and perhaps modify 1 or 2 of its other columns. With SQL Server Enterprise Manager, I can copy a row into a "new row" buffer, modify its primary key to ensure uniqueness, optionally modify 1 or 2 other columns, and paste the result into the table.

2b) Suppose I have two or more tables that have identical schemas (column names and types, primary key). I want to copy a set of rows from one table to another. (I've already verified that there will be no primary key conflicts.) With SQL Server Enterprise Manager, I can copy a set of rows from one table and paste them into another table.
Any help would be appreciated!
-Mike Wertheim
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

Nov 12 '05 #1
1 6545
Hi Mikew,

mi***@hyperreal.org schrieb:
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!)

I am very familiar with SQL Server's "Enterprise Manager", which is their GUI for accessing the db. I have been acquainting myself with pgAdmin. There are a number of things that I really like about pgAdmin, but there are a few things that SQL Server Enterprise manager can do, and it's not clear to me if pgAdmin can do them.
Unlike EM for SQL Server, there is no vendor developed and distributed
gui client for postgresql. While PgAdmin is probably the first choice,
there are a lot other tools for graphical manipulating postgresql
schema and data. Some of them are windows only, others are available
on different platforms too. See gborg or google for a reference
(There are even sposored links in google if you type in something
with "postgresql")
Can anyone let me know how the following things are done in the postgres world?
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.
alter table ...
2) With SQL Server Enterprise Manager, I can copy and paste rows. There are two scenarios:
create table ... as select ...
2a) Suppose I have a table that has some primary key, and it has a large number of non-null columns. Inserting a row can be tedious because I have to specify all the non-null values. What I often want to do is to duplicate a row, change its primary key, and perhaps modify 1 or 2 of its other columns. With SQL Server Enterprise Manager, I can copy a row into a "new row" buffer, modify its primary key to ensure uniqueness, optionally modify 1 or 2 other columns, and paste the result into the table.
alter table ... add column; update ... set newcolumn=oldcolumn;
alter table add constraint ...
2b) Suppose I have two or more tables that have identical schemas (column names and types, primary key). I want to copy a set of rows from one table to another. (I've already verified that there will be no primary key conflicts.) With SQL Server Enterprise Manager, I can copy a set of rows from one table and paste them into another table.

insert into othertable select * from thistable;

Any help would be appreciated!


Dont misunderstand me, I also valuate the easy use of gui admin tools,
but I also think a DBA schould have an in depth knowledge of the
database in the first place and be in principle able to handle
all tasks with SQL statements. And as it turns out, some things
(like copy table data between identical tables) is even simpler
with the statement instead of copy and paste.

Regards
Tino Wildenhain
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 12 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Bennett Haselton | last post by:
I want to get an ASP.Net hosting account with my ISP, and I'm trying to find out what level of access to the server is requried in order for me to view the server in Server Explorer in Visual...
3
by: David Gray | last post by:
Hello all, Having problems connecting to an Oracle 9i database from within SQL/Server 2000 using the Security/Linked Servers feature. Server1 (SQL/Server) ----------- Windows Server 2003,...
48
by: ik | last post by:
ERROR after uninstalling SQL Server 2005 Express I get this message, SQLDMO has not been registered. Please re-run your setupand contact your system administrator. GREAT!!! ReInstalled SQL...
0
by: Zorba.GR | last post by:
IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager...
14
by: David Tilman | last post by:
I've gone throught the MSDN walkthrough "Creating a Web Application Using Visual C# or Visual Basic". When I run the sample I get "Login failed for user 'dbuser'" at the line with...
2
by: AH | last post by:
Dear all, I am facing this 'bug' that really drive me nut. I created a trigger for Update script and tested in Enterprise manager to ensure it function correctly. However, when I used both VB or...
1
by: Alex | last post by:
Hi Everyone, Most of our MS SQL Servers are still running on SQL 2000, but being I will soon be upgrading my workstation to Vista Business I'd like to install MS SQL 2005 Enterprise Manager to...
2
by: =?Utf-8?B?QmV0bw==?= | last post by:
I am developing a ASP.NET application, with C# code-behind classes; with SQL Server 2000. All database access is made through stored procedures. I can insert, select and update in all tables...
2
by: Robert | last post by:
I'm a newbie trying to find the SQL Server Enterprise Manager so I can create a database. I have installed SQL Server 2005 Express and SQL Server Management Studio Express. On the SQL Server menu...
0
linyimin
by: linyimin | last post by:
Spring Startup Analyzer generates an interactive Spring application startup report that lets you understand what contributes to the application startup time and helps to optimize it. Support for...
0
by: erikbower65 | last post by:
Here's a concise step-by-step guide for manually installing IntelliJ IDEA: 1. Download: Visit the official JetBrains website and download the IntelliJ IDEA Community or Ultimate edition based on...
0
by: kcodez | last post by:
As a H5 game development enthusiast, I recently wrote a very interesting little game - Toy Claw ((http://claw.kjeek.com/))。Here I will summarize and share the development experience here, and hope it...
0
by: Taofi | last post by:
I try to insert a new record but the error message says the number of query names and destination fields are not the same This are my field names ID, Budgeted, Actual, Status and Differences ...
0
by: Rina0 | last post by:
I am looking for a Python code to find the longest common subsequence of two strings. I found this blog post that describes the length of longest common subsequence problem and provides a solution in...
5
by: DJRhino | last post by:
Private Sub CboDrawingID_BeforeUpdate(Cancel As Integer) If = 310029923 Or 310030138 Or 310030152 Or 310030346 Or 310030348 Or _ 310030356 Or 310030359 Or 310030362 Or...
0
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
0
by: Mushico | last post by:
How to calculate date of retirement from date of birth
2
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.