Re: pgAdmin - odd error

Since you dumped the data from a Windows system, the text file most likely
has both a CR and LF at the end of each line. UNIX systems don't really
like that. You need to change the CR/LF of Windows to the plain LF used by
Unix/Linux. See if you have a program named DOS2UNIX on your Linux
system. If so, use it. If not try:

tr -d 0x0d <dump.file.windows >dump.file.unix

Then import from dump.file.unix

John

On Mon, 6 Nov 2000 chriswood(at)wvda(dot)com wrote:

> 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
> --------------------------------------------------------
>