pg.ddx.io  pgsql-docs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Bruno Bonnefoy <bbonnefo@asi.fr>
To: docs@postgresql.org
Subject: a few questions
Date: Fri, 19 Feb 1999 17:15:15 +0100
Message-ID: <36CD8E13.F2FA1426@asi.fr> (raw)

Hello
i've got two questions :

1/ how can i load dequential files (list of records, one record per
line, fields in teh same line separated with teh PIPE caracter i.e) into

a postgresql database; I've tried the way i used to do it with informix
, by sql, typing :

load from "file " insert into table

where "file" is the name of my sequential file, and table is the name of

my postgresql destination table
In the same way, how can i "unload" the contents of my postgresql
database to sequential files ?


2/ what about ODBC drivers ? i've read many things concerning the
drivers, but don't know if they exist, for which operating systems and
file types, and how i could use them.

For instance i want to import into Microsoft Software (word, excel,
access) the contents of my postgresql database.

Thanks for all your answers.

Bruno Bonnefoy, Lyon, France






Message-ID: <36CD8E13.F2FA1426@asi.fr>
Permalink:  ../36CD8E13.F2FA1426@asi.fr/
Also on:    postgresql.org/message-id/36CD8E13.F2FA1426@asi.fr

 · 

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 using the --to and --cc options:
  reply via email

  To: pgsql-docs@postgresql.org
  Cc: bbonnefo@asi.fr, docs@postgresql.org
  Subject: Re: a few questions
  In-Reply-To: <36CD8E13.F2FA1426@asi.fr>

* 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