From philippe.gobin@fth.net Wed Apr 19 12:45:09 2000 Received: from smtp-out.fth.net (hermes2.pl.fth.net [193.252.69.8]) by hub.org (8.9.3/8.9.3) with ESMTP id IAA39657 for ; Wed, 19 Apr 2000 08:45:09 -0400 (EDT) (envelope-from philippe.gobin@fth.net) Received: from pgobin (pgobin.bu.fth.net [193.252.65.208]) by smtp-out.fth.net (8.8.8+Sun/8.8.8) with SMTP id OAA03558 for ; Wed, 19 Apr 2000 14:44:38 +0200 (MET DST) Message-ID: <00f301bfa9fd$26b21bd0$d041fcc1@bu.vtcom.fr> Reply-To: "Philippe Gobin" From: "Philippe Gobin" To: Subject: BLOB Date: Wed, 19 Apr 2000 14:45:25 +0200 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_00F0_01BFAA0D.E5F4B6A0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2314.1300 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300 X-Archive-Number: 200004/201 This is a multi-part message in MIME format. ------=_NextPart_000_00F0_01BFAA0D.E5F4B6A0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello I would like to know - how to create under psql a BLOB field in sql language - how store a value (and not a file) in sql language - the maximum size of the BLOB field=20 Thank you=20 pg ------=_NextPart_000_00F0_01BFAA0D.E5F4B6A0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hello
 
I would like to know
- how to create under psql a BL= OB=20 field in sql language
- how store a value (and not a file) in sql=20 language
- the maximum size of the BLOB field
 
Thank you
pg
 
------=_NextPart_000_00F0_01BFAA0D.E5F4B6A0-- From alligator@all.ee Sun May 13 14:03:02 2001 Received: from all.all.ee (puu.all.ee [194.204.49.113]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f4DE31A74298 for ; Sun, 13 May 2001 10:03:02 -0400 (EDT) (envelope-from alligator@all.ee) Received: from localhost (localhost [127.0.0.1]) by all.all.ee (8.9.3/8.9.3) with ESMTP id QAA32503 for ; Sun, 13 May 2001 16:02:54 +0200 Date: Sun, 13 May 2001 16:02:54 +0200 (EET) From: Antti Linno To: pgsql-sql@postgresql.org Subject: BLOB Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200105/118 X-Sequence-Number: 2934 Hallo. I was just searching documents how to define BLOB in postgres and couldn't find any hints. Could somebody enlighten me? Postgres is 7.0.3. I need to insert into DB text field more than 8000 symbols and there is no way, I can upgrade postgres to 7.1, so only way I see it's possible, is by defining a blob. Greetings, Antti