Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28]) by postgresql.org (8.11.3/8.11.1) with SMTP id f4EGUxA67652 for ; Mon, 14 May 2001 12:30:59 -0400 (EDT) (envelope-from pgsql-sql-owner@postgresql.org) Received: from fellini.mcmaster.wattle.id.au (woody.mcmaster.wattle.id.au [203.36.32.213]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f4D86EA40963 for ; Sun, 13 May 2001 04:06:19 -0400 (EDT) (envelope-from rmcm@compsoft.com.au) Received: (from rex@localhost) by fellini.mcmaster.wattle.id.au (8.11.0/8.11.0) id f4D85g112370; Sun, 13 May 2001 18:05:42 +1000 (EST) From: rmcm@compsoft.com.au X-Authentication-Warning: fellini.mcmaster.wattle.id.au: rex set sender to Rex McMaster using -f MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Message-ID: <15102.16469.969702.883536@fellini.mcmaster.wattle.id.au> Date: Sun, 13 May 2001 18:05:41 +1000 (EST) To: "Sylte" Cc: pgsql-sql@postgresql.org Subject: Re: Re: Informix->PostgreSQL database convertion In-Reply-To: <9dh6o1$hb9$1@sunsite.dk> References: <9d8r7v$1to$1@sunsite.dk> <9d90cl$sv8$1@news.tht.net> <9dh6o1$hb9$1@sunsite.dk> X-Mailer: VM 6.75 under Emacs 20.7.1 Reply-To: Rex McMaster X-Archive-Number: 200105/125 X-Sequence-Number: 2941 is there an informix utility called dbschema which does this? dbschema -t all -d databasename > schema.sql Sylte writes: > How is the SQL command UNLOAD (informix) used to extract both data and > database architecture? > > Is it able to create a file of SQL statements like when using postgresql's > command "pg_dump -f outputfile mydb" > > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://www.postgresql.org/search.mpl -- Rex McMaster