pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: rmcm@compsoft.com.au
To: Sylte <Sylte_@hotmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Re: Informix->PostgreSQL database convertion
Date: Sun, 13 May 2001 18:05:41 +1000 (EST)
Message-ID: <15102.16469.969702.883536@fellini.mcmaster.wattle.id.au> (raw)
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>

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



view thread (5+ messages)

Message-ID: <15102.16469.969702.883536@fellini.mcmaster.wattle.id.au>
Permalink:  ../15102.16469.969702.883536@fellini.mcmaster.wattle.id.au/
Also on:    postgresql.org/message-id/15102.16469.969702.883536@fellini.mcmaster.wattle.id.au

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: rmcm@compsoft.com.au, Sylte_@hotmail.com
  Subject: Re: Informix->PostgreSQL database convertion
  In-Reply-To: <15102.16469.969702.883536@fellini.mcmaster.wattle.id.au>
  References: <9d8r7v$1to$1@sunsite.dk> <9d90cl$sv8$1@news.tht.net> <9dh6o1$hb9$1@sunsite.dk> <15102.16469.969702.883536@fellini.mcmaster.wattle.id.au>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox