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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
