By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,640 Members | 2,118 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,640 IT Pros & Developers. It's quick & easy.

What is the maximum size of data can I retrive it in postgresql?

P: 61
when I deal with a big data which is of text data-type

the insert and update statments done successfully.

After that, I tried to retrive this data which about

(2.9)Mega-Byte, but the query failed!!

How can I fix this problem?
Oct 18 '10 #1
Share this Question
Share on Google+
5 Replies

Expert 100+
P: 700
How do you retrive data, do you use database client (pgadmin3, psql ?) or some dedicated application you wrote in some language?
Oct 20 '10 #2

P: 61
I retrive data by select statement on a column of text data-type and use the where clouse to retrive one field which is
contain a big data (about 2.9 mega bytes).
the queryis like:
select message from my_table where id = 7;

I use Pgadmin3.

Oct 21 '10 #3

Expert 100+
P: 700
What about psql client, does it also throw an error? maybe it is pgadmin3 bug.
Oct 21 '10 #4

P: 61
I didn't try with psql
(I don't know how to run it, is it installed with Pgadmin3?)

Oct 21 '10 #5

Expert 100+
P: 700
psql is installed with postgres.
Nov 14 '10 #6

Post your reply

Sign in to post your reply or Sign up for a free account.