Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 2C05B475F23
	for <pgsql-sql@postgresql.org>; Fri, 25 Oct 2002 02:26:36 -0400 (EDT)
Received: from gnumed.dyndns.org (203-109-224-216.ultrawholesale.com.au
	[203.109.224.216])
	by postgresql.org (Postfix) with SMTP id 2F99A475EBD
	for <pgsql-sql@postgresql.org>; Fri, 25 Oct 2002 02:26:33 -0400 (EDT)
Received: (qmail 2840 invoked from network); 19 Oct 2002 00:22:45 -0000
Received: from pc-00088 (192.168.1.88)
	by bifrost.gnumed.dyndns.org (192.168.1.1) with ESMTP;
	19 Oct 2002 00:22:45 -0000
From: Horst Herb <subscriptions@gnumed.net>
Organization: gnumed
To: "John Geng" <lanlz@sina.com>
Subject: Re: help!
Date: Sat, 19 Oct 2002 10:22:44 +1000
User-Agent: KMail/1.4.7
References: <20021016091128.D2625475BF9@postgresql.org>
In-Reply-To: <20021016091128.D2625475BF9@postgresql.org>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="gb2312"
Content-Transfer-Encoding: 8bit
Content-Disposition: inline
Message-Id: <200210191022.44280.subscriptions@gnumed.net>
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200210/347
X-Sequence-Number: 10064

On Wed, 16 Oct 2002 19:15, John Geng wrote:
> how to migrate sql from MS sql server to postgresql?
> i'd like to tranfer sql schema from MS server
> Example:
> *******************1*********************************
> if exists (select * from sysobjects
> where id = object_id(N'[admin].[test]') and
> OBJECTPROPERTY(id, N'IsUserTable') = 1)
> drop table [admin].[test]

if exists (select * from pg_tables where tablename = '<your table name goes 
here')

might be what you are looking for

Horst