Index: doc/src/sgml/datatype.sgml =================================================================== RCS file: /home/projects/pgsql/cvsroot/pgsql/doc/src/sgml/datatype.sgml,v retrieving revision 1.60 diff -c -r1.60 datatype.sgml *** doc/src/sgml/datatype.sgml 2001/08/31 01:55:25 1.60 --- doc/src/sgml/datatype.sgml 2001/09/04 03:15:49 *************** *** 84,89 **** --- 84,95 ---- + bytea + + binary data + + + character(n) char(n) fixed-length character string *************** *** 782,788 **** text Variable unlimited length ! --- 788,798 ---- text Variable unlimited length ! ! bytea ! binary data ! ! *************** *** 827,832 **** --- 837,855 ---- does not require an explicit declared upper limit on the size of the string. Although the type text is not in the SQL standard, many other RDBMS packages have it as well. + + + + The bytea data type allows storage of binary data, + specifically allowing storage of NULLs which are entered as + '\\000'. The first backslash is interpreted by the + single quotes, and the second is recognized by bytea and + preceeds a three digit octal value. For a similar reason, a + backslash must be entered into a field as '\\\\' or + '\\134'. You may also have to escape line feeds and + carriage return if your interface automatically translates these. It + can store values of any length. Bytea is a non-standard + data type.