On Tue, Jan 28, 2003 at 23:39:47 -0500,
Wei Weng [EMAIL PROTECTED] wrote:
What about a UNIQUEIDENTIFIER type?
You probably want to use serial type as a replacement. Serial is really
int with a default obtained using a sequence.
---(end of
Hello all,
I a m a new member of the list and at the moment , I am studiing
informatica: sql.
At the workplace, we use microsoft sql server 2000.
At home, I use postgresql 7.2.1 and now I would import the data of the
database at the workplace into the postgresql environment at home.
I have
Can someone tell me how I can adjust the syntax of the code and in global:
how can I convert sql-code , for microsoft sql server 2000, to sql-code for
postgresql?
Try,
http://techdocs.postgresql.org/techdocs/sqlserver2pgsql.php
regards,
bhuvaneswaran
---(end of
On Tuesday 28 January 2003 10:08 am, william windels wrote:
A lot of SQL! Instead of spending a lot of time trying to figure out what's
wrong with your code, here's a couple of links that should help you:
The most obvious is the PostgreSQL documentation which can be found in the doc
directory
Only 1 small change makes it acceptable to pgsql.
change datetime to timestamp .
regds
mallah.
On Tuesday 28 January 2003 03:38 pm, william windels wrote:
Hello all,
I a m a new member of the list and at the moment , I am studiing
informatica: sql.
At the workplace, we use microsoft sql
Hi
You should use date instead of datetime since the data is only a date and
a date type uses less storage than a timestamp.
For time only data use type time or timetz if you want the timezone as
well. For data with a date and time use timestamp or timestamptz if you
want to include the
--- william windels [EMAIL PROTECTED]
wrote:
how can I convert sql-code , for microsoft sql
server 2000, to sql-code for
postgresql?
In addition to the suggestions given in other replies,
have a look at PGAdminII:
http://pgadmin.postgresql.org
That is an excellent utility, and comes with a
Guy Fraser [EMAIL PROTECTED] writes:
If you go through the documentation you can also find out how to CREATE your
own data TYPE to allow more direct use of non-PostgreSQL data types. Here is
an example that will allow input of any datetime data into PostgreSQL :
CREATE TYPE datetime AS
]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, January 28, 2003 8:55 PM
Subject: Re: [SQL] converting microsoft sql server 2000 sql-code for
postgresql
Guy Fraser [EMAIL PROTECTED] writes:
If you go through the documentation you can also find out how to CREATE
your
own data TYPE to allow more direct