Re: Converting from .MDB Access to PostgreSQL - Mailing list pgsql-general

From Chris Albertson
Subject Re: Converting from .MDB Access to PostgreSQL
Date
Msg-id 20020710005408.30374.qmail@web14702.mail.yahoo.com
Whole thread Raw
In response to Converting from .MDB Access to PostgreSQL  ("Bob Puff@NLE" <bob@nleaudio.com>)
Responses Re: Converting from .MDB Access to PostgreSQL
List pgsql-general
I'm sure you can get MS Access to dump its data into a
comma or pipe delimited ASCII file.  If so, Postgresql's
COPY command (see "man copy") can read these files.  It is
mostly painless unless there are many tables.


--- "Bob Puff@NLE" <bob@nleaudio.com> wrote:
<SNIP>
>

>
> I assume there are two distinct functions that need to be done:
>    1. Create the databases, with the appropriate tables and columns
>    2. Move the data within the database.
>
> I did do some searching on the site, but most of the stuff didn't
> quite "click".  Any advice given
> would be greatly appreciated.  Thanks!
>
> Bob
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster


=====
Chris Albertson
  Home:   310-376-1029  chrisalbertson90278@yahoo.com
  Cell:   310-990-7550
  Office: 310-336-5189  Christopher.J.Albertson@aero.org

__________________________________________________
Do You Yahoo!?
Sign up for SBC Yahoo! Dial - First Month Free
http://sbc.yahoo.com

pgsql-general by date:

Previous
From: ljb
Date:
Subject: Re: Frontend/backend protocol: authentication
Next
From: Bruce Momjian
Date:
Subject: Re: Redhat/glibc and postgre time "bug"