Kevin Kempter <kevink@xxxxxxxxxxxxxxxxxxx> wrote: > we want to insert a single backslash into a bytea column (running postgres v > 8.3.5) > this works to insert 2 backslashes (but we only want one): > insert into test_bytea_tab (id, bytea_test_col) > values(999999, '\\\\testdata'::bytea) > [...] This inserts a single backslash. Check LENGTH(bytea_test_col). Tim -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin