Received: from mta1.snet.net (mta1.snet.net [204.60.203.70]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g0IJqhV79358 for ; Fri, 18 Jan 2002 14:52:43 -0500 (EST) (envelope-from wweng@kencast.com) Received: from pop.snet.net (pop.snet.net [204.60.203.72]) by mta1.snet.net (8.12.1/8.12.1/SNET-smtp-1.1/D-1.1/O-1.1) with ESMTP id g0IJpROZ027658 for ; Fri, 18 Jan 2002 14:51:28 -0500 (EST) Received: from Monet (167.95.252.64.snet.net [64.252.95.167]) by pop.snet.net (8.12.1/8.12.1/SNET-pop-1.2/D-1.2/O-1.3) with SMTP id g0IJqY2T002783 for ; Fri, 18 Jan 2002 14:52:34 -0500 (EST) Date: Fri, 18 Jan 2002 14:59:46 -0500 From: Wei Weng To: pgsql-sql@postgresql.org Subject: Conditionally create table problem Message-Id: <20020118145946.0c4d957b.wweng@kencast.com> In-Reply-To: <200201181627.g0IGRTV91993@postgresql.org> References: <200201181627.g0IGRTV91993@postgresql.org> Organization: KenCast Inc. X-Mailer: Sylpheed version 0.7.0 (GTK+ 1.2.10; i586-pc-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Archive-Number: 200201/225 X-Sequence-Number: 6309 Is there better way to conditionally create tables rather than doing SELECT sp_CheckTable_tablename(); ? (In sp_CheckTable_tablename, we will basically query the pg_tables and create the table if it doesn't exists and do nothing it it does.) TIA. -- Wei Weng Network Software Engineer KenCast Inc.