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