How to store big character data in postgres.

[Madhi Krishnan]

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

[grv]

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 <
[hidden email]> 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
>

[Rishi Solanki]

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: [phone]
http://www.hotwaxsystems.com
www.hotwax.co


On Sat, Oct 27, 2018 at 1:48 PM Madhi Krishnan <
[hidden email]> 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
>

[Madhi Krishnan]

Thank you all...
Type='Text'  Worked for me..

On Sat, Oct 27, 2018 at 2:10 PM Rishi Solanki <[hidden email]>
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: [phone]
> http://www.hotwaxsystems.com
> www.hotwax.co
>
>
> On Sat, Oct 27, 2018 at 1:48 PM Madhi Krishnan <
> [hidden email]> 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
> >
>