From: | Chris Albertson <chrisalbertson90278(at)yahoo(dot)com> |
---|---|
To: | "Bob Puff(at)NLE" <bob(at)nleaudio(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Converting from .MDB Access to PostgreSQL |
Date: | 2002-07-10 00:54:08 |
Message-ID: | 20020710005408.30374.qmail@web14702.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)NLE" <bob(at)nleaudio(dot)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(at)yahoo(dot)com
Cell: 310-990-7550
Office: 310-336-5189 Christopher(dot)J(dot)Albertson(at)aero(dot)org
__________________________________________________
Do You Yahoo!?
Sign up for SBC Yahoo! Dial - First Month Free
http://sbc.yahoo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2002-07-10 02:06:44 | Re: Redhat/glibc and postgre time "bug" |
Previous Message | ljb | 2002-07-10 00:42:13 | Re: Frontend/backend protocol: authentication |