X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id BD32AD1B52D for ; Tue, 18 Nov 2003 19:12:32 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 95671-02 for ; Tue, 18 Nov 2003 15:12:02 -0400 (AST) Received: from b0x.supernerd.com (unknown [208.186.134.90]) by svr1.postgresql.org (Postfix) with ESMTP id D8D8DD1B50A for ; Tue, 18 Nov 2003 15:12:00 -0400 (AST) Received: from trogdor (unknown [67.42.122.198]) by b0x.supernerd.com (Postfix) with ESMTP id 1ED395FD1B for ; Tue, 18 Nov 2003 12:07:58 -0700 (MST) Message-ID: <019301c3ae07$d714e220$0700a8c0@trogdor> From: "Rick Gigger" To: "PgSQL General ML" References: <1069164075.986.239.camel@bbking.uio.no> <20031118142919.GI4953@libertyrms.info> <1069180780.2769.91.camel@haggis.homelan> Subject: uploading files Date: Tue, 18 Nov 2003 12:11:53 -0700 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests=REFERENCES X-Spam-Level: X-Archive-Number: 200311/933 X-Sequence-Number: 52583 What is the best method for storing files in postgres? Is it better to use the large object functions or to just encode the data and store it in a regular text or data field?