From: James Olin Oden <joden@Lee.k12.nc.us>
To: Alexander Elsenaar <a.elsenaar@viewpoint.nl>
To: pgsql-interfaces@postgresql.org
Subject: Re: [INTERFACES] Using psqlodb.dll with a 16-bits application
Date: Tue, 7 Jul 1998 12:49:00 -0400
Message-ID: <81Jul6.114032edt.35713@gateway.lee.k12.nc.us> (raw)
References: <01BDA9A9.60F862A0@topline>
> It is not a regular application but a development environment. (Clarion for Windows 2.003) and I am trying to import a table definition. Any other sugestion?
If this is just a one time thing and you are going from Clarion to Postgress, just export the DBF files (I believe Clarion is DBF formated) as SDF format, and transfer this file over to the Postgres machine. Once there use the copy command to get them in, or write a quick awk script to generate a bunch of selects.
If your going the other way do a select on the table selecting all fields, such as:
select * from blah;
write this select statement to a file and then type:
psql -f queryfile > results
Now you have a fixed length text file (with little bars between each field). With a little massaging you should be able to export it into Clarion.
These are one time solutions though, and will not help you if you need to do this over and over again...james
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 using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: joden@Lee.k12.nc.us, a.elsenaar@viewpoint.nl
Subject: Re: [INTERFACES] Using psqlodb.dll with a 16-bits application
In-Reply-To: <81Jul6.114032edt.35713@gateway.lee.k12.nc.us>
* 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