Re: Differences between bit string constant sintax

On 2009-09-09, Oliveiros C, <oliveiros.cristina@marktest.pt> wrote:
> This is a multi-part message in MIME format.
>
> ------=_NextPart_000_013B_01CA3146.85B62920
> Content-Type: text/plain;
>     charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> 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.

copy syntax differs from literal syntax in several ways
(an obvious one is that tabs are allowed in literals)
in this case you don't use quotes in the value.


copy mytable from stdin;
4      xdeadbeef
5      x123
\.