- Архив списков рассылки pgsql-sql

<p><font color="#0000ff">how to migrate sql from MS sql server to postgresql?</font><p><br />i'd like to tranfer sql
schemafrom MS server<br />Example:<br />*******************1*********************************<br />if exists (select *
fromsysobjects <br />where id = object_id(N'[admin].[test]') and <br />OBJECTPROPERTY(id, N'IsUserTable') = 1)<br
/>droptable [admin].[test] <br />go<br />*******************2*********************************<br />CREATE TABLE
[admin].[test](<br />[test_name] [char] (50) NOT NULL ,<br />[test_value] [int] NOT NULL <br />)<p>   i can only
realizepart 2. i don't know how to realize part 1.in other words,<br />i want to know how to check if a table exist in
postgresql<br/>*******************2*********************************<br />  create table test(<br />   test_name char
(50)not null,<br />   test_value int not null<br />  )<p>thanks for any advice!!