You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Madhi Krishnan <ma...@udyogmandir.in> on 2018/10/27 08:17:50 UTC
How to store big character data in postgres.
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
Re: How to store big character data in postgres.
Posted by Girish Vasmatkar <gi...@hotwaxsystems.com>.
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
>
Re: How to store big character data in postgres.
Posted by Madhi Krishnan <ma...@udyogmandir.in>.
Thank you all...
Type='Text' Worked for me..
On Sat, Oct 27, 2018 at 2:10 PM Rishi Solanki <ri...@gmail.com>
wrote:
> Either you should go for Content data model and store your query in
> ElectronicText.textData field.
> Or you should use very-long field type for your purpose where your are
> storing the query data.
>
>
> --
> Rishi Solanki
> Sr Manager, Enterprise Software Development
> HotWax Systems Pvt. Ltd.
> Direct: +91-9893287847
> http://www.hotwaxsystems.com
> www.hotwax.co
>
>
> 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
> >
>
Re: How to store big character data in postgres.
Posted by Rishi Solanki <ri...@gmail.com>.
Either you should go for Content data model and store your query in
ElectronicText.textData field.
Or you should use very-long field type for your purpose where your are
storing the query data.
--
Rishi Solanki
Sr Manager, Enterprise Software Development
HotWax Systems Pvt. Ltd.
Direct: +91-9893287847
http://www.hotwaxsystems.com
www.hotwax.co
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
>