Skip site navigation (1) Skip section navigation (2)

a few questions

From: Bruno Bonnefoy <bbonnefo(at)asi(dot)fr>
To: docs(at)postgresql(dot)org
Subject: a few questions
Date: 1999-02-19 16:15:15
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-docs
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

pgsql-docs by date

Next:From: Bruce MomjianDate: 1999-02-21 20:50:42
Subject: Update contributors page
Previous:From: ZinchikDate: 1999-02-19 12:57:57
Subject: unsubscribe

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group