Error at import data to postgresql using copy with delimiter

Question

im am importing data to postgresql with this comand

COPY codigos_postales 
(CPRO, CMUN, Nombre_Municipio, CP, Municipio_CP, Lugar_CP) 
FROM 'path' WITH DELIMITER E'/t';

But i got this error.

ERROR: COPY delimiter must be a single-byte character

Craig Ringer · Accepted Answer · 2014-03-19 01:15:18Z

1

If you're trying to specify a tab as the delimiter, you want E'\t' (the escape character is a backslash not a forward slash) or just a literal tab ' '.

You can see that with:

regress=>     SELECT E'\t' AS backslash, E'/t' AS forwardslash;
 backslash | forwardslash 
-----------+--------------
           | /t
(1 row)

If the delimiter is actually the string /t then you won't be able to use COPY, as it only supports single character delimiters.

answered Mar 19, 2014 at 1:15

Craig Ringer

329k84 gold badges743 silver badges821 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

mig8 · Accepted Answer · 2014-03-18 19:00:53Z

0

your delimiter looks like a little bit complex but not a single byte char... Try with '\t'.

answered Mar 18, 2014 at 19:00

mig8

1224 bronze badges

Collectives™ on Stack Overflow

Error at import data to postgresql using copy with delimiter

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related