Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 4813F9FB1F7 for ; Sat, 21 Oct 2006 00:55:22 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 73352-01 for ; Sat, 21 Oct 2006 00:55:17 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from relais.videotron.ca (relais.videotron.ca [24.201.245.36]) by postgresql.org (Postfix) with ESMTP id 89A749FA469 for ; Sat, 21 Oct 2006 00:55:17 -0300 (ADT) Received: from tedy ([70.82.131.58]) by VL-MH-MR002.ip.videotron.ca (Sun Java System Messaging Server 6.2-2.05 (built Apr 28 2005)) with ESMTP id <0J7G00BWSW840CA9@VL-MH-MR002.ip.videotron.ca> for pgsql-sql@postgresql.org; Fri, 20 Oct 2006 23:55:16 -0400 (EDT) Date: Fri, 20 Oct 2006 23:55:10 -0400 From: Daniel CAUNE Subject: Re: conversion of numeric field from MSSQL to postgres In-reply-to: <41AFC3C5-7FB6-4EE7-9AE5-88234C2DC6B1@au-kbc.org> To: 'Kenneth Gonsalves' , pgsql-sql@postgresql.org Message-id: <000d01c6f4c4$b48acb00$0b00a8c0@tedy> MIME-version: 1.0 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.2962 X-Mailer: Microsoft Office Outlook 11 Content-type: text/plain; charset=iso-8859-1 Content-transfer-encoding: quoted-printable Thread-index: Acb0wN54dfsAgs4lR+6vPRCc/SgOwgAAwlKA X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200610/188 X-Sequence-Number: 26577 > De=A0: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org] > De la part de Kenneth Gonsalves > Envoy=E9=A0: 15 octobre 2006 08:31 > =C0=A0: pgsql-sql@postgresql.org > Objet=A0: [SQL] conversion of numeric field from MSSQL to postgres >=20 > hi, >=20 > am migrating a database from MSSQL to postgres. How would i migrate > this: >=20 > [Id] [numeric](18, 0) IDENTITY (1, 1) >=20 It seems that you've already asked for this question last Sunday, and because your question is somewhat deterministic, the answers are more = likely to be the same. Check your previous e-mails. -- Daniel