Skip site navigation (1) Skip section navigation (2)

Re: Converting a table from SQL Server

From: "Sean Davis" <sdavis2(at)mail(dot)nih(dot)gov>
To: "Bob McConnell" <rmcconne(at)lightlink(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Converting a table from SQL Server
Date: 2008-08-31 14:01:32
Message-ID: 264855a00808310701p74dc3a52s96ac3818ceb4aafb@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
On Sun, Aug 31, 2008 at 9:03 AM, Bob McConnell <rmcconne(at)lightlink(dot)com> wrote:
> I am just beginning to learn a number of new tools simultaneously, so please
> bear with me. I have installed Apache 2.2, PHP 5 and PostgreSQL 8.2.1 on a
> couple of servers to play with. I also have pgAdmin III 1.8.4 running on one
> workstation which is able to connect with each server. I am not yet fully
> happy with the results, but they are close enough now for me to start trying
> a few experiments.
>
> I found the text below while searching for something on Google. Based on the
> site it was posted to, I believe it is for SQL Server. I would like to
> convert it into Postgres and make it a standard component of every database
> I build. (I added the PatchNumber field.)
>
> But I have only found articles on how to convert from MySQL to Postgres and
> a few on how to convert from SQL Server to MySQL. So how do I translate this
> without leaving the bad taste of MySQL in my mouth? Or is there a similar
> recommended practice for Postgres?

Do you mean that you want an auto-translator for SQL Server to
Postgres?  Or do you mean that you just need help with Postgresql
syntax?  If it is the latter, the docs for postgresql are quite good:

http://www.postgresql.org/docs/8.2/static/

Sean

In response to

Responses

pgsql-novice by date

Next:From: Bob McConnellDate: 2008-08-31 14:19:53
Subject: Re: Converting a table from SQL Server
Previous:From: Bob McConnellDate: 2008-08-31 13:03:24
Subject: Converting a table from SQL Server

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group