From: Oliveiros C, <oliveiros.cristina@marktest.pt>
To: pgsql-sql@postgresql.org
Subject: Differences between bit string constant sintax
Date: Wed, 9 Sep 2009 12:10:29 +0100
Message-ID: <164F217AD1FE44F0B6D4CE0AE7369D54@marktestcr.marktest.pt> (raw)
Dear All,
I have a table which has a field that is of type bit varying.
When I do a direct INSERT with , say, X'1F', everything
works fine.
But in this table I have to insert several tens of thousands
of records each time, so I decided to use
COPY command.
And if I build a file like this (columns separated by tab char)
primary_key1 X'1F'
primary_key2 X'1FF'
...
The system will complain on the first line,
saying that ' is not an hexadecimal digit.
I tried to remove the single quotes and it worked fine...
With values like this : X1F, X1FF, etc
Is the system supposed to behave like this, or have
I gone sideways somewhere on this?
My copy command is just this :
COPY t_unique_browsers
("IDUniqueBrowsers","browsersSet")
FROM $file$C:\temp\pg\totalAccount.sql$file$;
Also,
SELECT version() says :
"PostgreSQL 8.3.7, compiled by Visual C++ build 1400"
Thanx in advance for your help
Best,
Oliveiros
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: oliveiros.cristina@marktest.pt
Subject: Re: Differences between bit string constant sintax
In-Reply-To: <164F217AD1FE44F0B6D4CE0AE7369D54@marktestcr.marktest.pt>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox