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 broadcast)--
t;Guy Fraser" <[EMAIL PROTECTED]>
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
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
--- 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 wit
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 in
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 microsof
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 of
> 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
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 paste
