From user-return-54473-archive-asf-public=cust-asf.ponee.io@ofbiz.apache.org Sat Oct 27 10:39:37 2018 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by mx-eu-01.ponee.io (Postfix) with SMTP id 72190180649 for ; Sat, 27 Oct 2018 10:39:37 +0200 (CEST) Received: (qmail 62867 invoked by uid 500); 27 Oct 2018 08:39:36 -0000 Mailing-List: contact user-help@ofbiz.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@ofbiz.apache.org Delivered-To: mailing list user@ofbiz.apache.org Received: (qmail 62855 invoked by uid 99); 27 Oct 2018 08:39:35 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd1-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 27 Oct 2018 08:39:35 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd1-us-west.apache.org (ASF Mail Server at spamd1-us-west.apache.org) with ESMTP id 2A543D2D6F for ; Sat, 27 Oct 2018 08:39:35 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd1-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.997 X-Spam-Level: * X-Spam-Status: No, score=1.997 tagged_above=-999 required=6.31 tests=[DKIMWL_WL_MED=-0.001, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H2=-0.001, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd1-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=hotwaxsystems-com.20150623.gappssmtp.com Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd1-us-west.apache.org [10.40.0.7]) (amavisd-new, port 10024) with ESMTP id 2iU3WGdZ4WrG for ; Sat, 27 Oct 2018 08:39:34 +0000 (UTC) Received: from mail-lj1-f172.google.com (mail-lj1-f172.google.com [209.85.208.172]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTPS id 2821A5F19D for ; Sat, 27 Oct 2018 08:39:34 +0000 (UTC) Received: by mail-lj1-f172.google.com with SMTP id v6-v6so3265732ljc.11 for ; Sat, 27 Oct 2018 01:39:34 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=hotwaxsystems-com.20150623.gappssmtp.com; s=20150623; h=mime-version:references:in-reply-to:from:date:message-id:subject:to; bh=mFZhqMplr9VQKBluF6TIFnlAMPXHAwq5HXqoa3HeWOY=; b=nb1J0vPWUtku7cv8k1xZNtAqs3FlhRlsYssbZ2D339XQNoAnOA1PcW0fIzEbEhu/wN xnh2OFt7Fukd4WdkuFrk/gh3kezwQd33ilp7jTzFYGiU2Hj7/QAtjTYHvM8nPTVF7/js iZbBQ+UIXYkbi5sZKcxdgmBod6rbGx8EnG4XBbGmlyKnVne7j+MAhJubDh3aMn5QhITt Wfa0RamMNWacl54GShags4yuMJ22LRcIV/9oAu5ADl+dTTtcR7Ieq/clOVqO0oDmnXtq nXI3uWjS6u6APbSVb+mTNiiYujHAxEkonBFU026754ofqj2kShxOBoqTOW9GPiTe5xkF V3xw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to; bh=mFZhqMplr9VQKBluF6TIFnlAMPXHAwq5HXqoa3HeWOY=; b=QvO+7vmYN74KZNaucKYYsYmAtojiqZjBmH/JsWxOWK4Xx4U3yV2QIkmCbGVg4X2q3S YELE04IG9JePv79mT9mJQsILPgi1UJ7ukm/JtQwuRF9Gz5afz7ZdKRRoV/rmNEcYYaWm foQhNPxbHKf0dG9frSxgJgBadu5K7+Dlb9gc8Q1OcpcwPmoKVanarop8hu0/vnr8V3hR Rcb7papGcOgEt8zs2BAHA4KC7QGe6JQ+2CZJa9siI0ITPELuBAnS7MqQcAIJTbMasnr4 vjvnJ9vwGVX/X6TmB1eDRopYCWArujUyFH1Ivw6on4/kUcwC82x84R34PQQaZMJ1oav4 efzw== X-Gm-Message-State: AGRZ1gJpevxL4V6K73S2azPAYgH8dOElBWrTAy+CSeTWj4CuU45/95T4 vRcGsUbVp5gWtm2c/vO9q6ZsO64fND7fW6P86be5b4sdsKY= X-Google-Smtp-Source: AJdET5cXa5fz6eKqIln9e5ek4ofitoG6d/pVP37xq0RNMi9kFgaCWB2AdHaTxWVDh54b6ipXG++tIOkaNoWT4825OZM= X-Received: by 2002:a2e:5418:: with SMTP id i24-v6mr4178107ljb.51.1540629572524; Sat, 27 Oct 2018 01:39:32 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Girish Vasmatkar Date: Sat, 27 Oct 2018 14:09:21 +0530 Message-ID: Subject: Re: How to store big character data in postgres. To: user@ofbiz.apache.org Content-Type: multipart/alternative; boundary="00000000000066c787057931c69e" --00000000000066c787057931c69e Content-Type: text/plain; charset="UTF-8" Hi Madhi Why would you want to store a SQL Query in the DB? What's the length of the query? You can use type "text" with unlimited length. What's the current data type of the column you're trying to store your query in? Postgres implements CLOBs using TEXT datatype. You should consider using TEXT. Best, Girish Vasmatkar HotWax Systems On Sat, Oct 27, 2018 at 1:48 PM Madhi Krishnan < madhi.krishnan@udyogmandir.in> wrote: > Hey all.. > I'm trying to store a sql query in postgres.. > but it's not storing because of query being too long.. > can any one tell me how to store big character data .. > and i got something call ''clob'' . > if Anyone have come exapmle of clob will be good.. > Thank You > --00000000000066c787057931c69e--