Re: access database conversion

On Wed, 20 Feb 2002 20:36:44 +0100
Hugo Coolens <hugo(dot)coolens(at)skynet(dot)be> wrote:

> I have exported an access database in csv-format with the first line the
> names of the attributes. I now want to make a postgresql database from
> this, what's the most efficient way to follow?
>
> hugo
>

bnl=# \h copy
Command: COPY
Description: Copies data between files and tables
Syntax:
COPY [ BINARY ] table [ WITH OIDS ]
FROM { 'filename' | stdin }
[ [USING] DELIMITERS 'delimiter' ]
[ WITH NULL AS 'null string' ]

COPY [ BINARY ] table [ WITH OIDS ]
TO { 'filename' | stdout }
[ [USING] DELIMITERS 'delimiter' ]
[ WITH NULL AS 'null string' ]

example
copy mytable from '/tmp/myfile' using delimiters ';' with null as 'whatever_you_have_for_null_if_any'

Remove the headings from the file first, andmake sure Mytable matches the fields in Myfile

regards
Björn