Received: from goofy.fi.upm.es (goofy.fi.upm.es [138.100.8.23]) by hub.org (8.8.8/8.7.5) with ESMTP id NAA13306 for ; Thu, 10 Sep 1998 13:10:23 -0400 (EDT) Received: from dilmun.ls.fi.upm.es (dilmum.ls.fi.upm.es) by relay.fi.upm.es (PMDF V5.1-12 #U3185) with ESMTP id <01J1NHP2YP0U00015X@relay.fi.upm.es> for pgsql-sql@postgresql.org; Thu, 10 Sep 1998 19:08:38 MET-DST Received: from dilmun.ls.fi.upm.es by dilmun.ls.fi.upm.es (8.8.5/FI-4.1) Thu, 10 Sep 1998 19:08:37 +0200 Date: Thu, 10 Sep 1998 19:12:24 +0200 From: Juan Valero Subject: Binary variable length string To: pgsql-sql@postgresql.org Message-id: <35F80878.2CBA1890@dilmun.ls.fi.upm.es> MIME-version: 1.0 X-Mailer: Mozilla 4.06 [en] (WinNT; I) Content-type: text/plain; charset=us-ascii Content-transfer-encoding: 7bit Hello, I am new in PostgreSQL. My problem is that I don't know how to create a table with a binary variable length string. I don't know what is the correct type in PostgreSQL and how to make the sql sentence. i.e.: create table mytable (id ??????); -- I want a binary string insert into mytable (0x00 0x01 0xAF); -- Binary data ???? Thanks in advance Sorry for my English.