pgAdmin - odd error

From: chriswood(at)wvda(dot)com
To: pgsql-novice(at)postgresql(dot)org
Subject: pgAdmin - odd error
Date: 2000-11-06 19:45:25
Message-ID: 3A06D215.6689.39AC8D@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

When using pgAdmin in trying to import an Access97-exported
text file into my PostgreSQL database, I'm getting this error:

Tuple: 1
Error: Too many quote characters found.
Expected: 54
Found: 96

Oddly enough, pgadmin seems to be seeing every
second line in the text file as one line. Any
clue as to what's happening?

I'm using "|" as my delimiter, and "`" as my
text quotation mark, to avoid conflict with the
standard keyboard " and '.

I can't seem to access the list archives right
now, so I'm asking the list.

--------------------------------------------------------
Christopher Wood, Community Access Technical Coordinator
Western Valley Development Authority
Nova Scotia's Smart Community
Box 251 Bridgetown, Nova Scotia B0S 1C0
tel: (902) 665-4083/ fax: (902) 665-2878
www.wvda.com www.wvcn.ns.ca
--------------------------------------------------------

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message John McKown 2000-11-06 21:01:23 Re: pgAdmin - odd error
Previous Message Ian Kulmatycki 2000-11-06 15:26:45 Email and Postgres