What is maximum size of text datatype in postgres?



What is maximum size of text datatype in postgres?..

Answer / Ravi Chaudhary

The maximum size for the TEXT data type in PostgreSQL is approximately 1GB (1073741823 bytes), but this can be extended by changing the shared_buffers configuration parameter.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Postgre Interview Questions

i have three table 1. student (stuid,name) 2. subject (subid,sname,studid) 3. marks (subid,studentid,marks) i want the reslut of how as got max marks in each subject sudentname,max(marks), name abc,70,nikitha

1 Answers   CMC,


What is dummy table?

1 Answers  


Explain about concurreny with the help of MVCC?

1 Answers  


How do I import a csv file into postgres?

1 Answers  


How to get month wise data in postgresql?

1 Answers  


What is catalog in postgresql?

1 Answers  


How do you delete a row in a table?

1 Answers  


What is psql command?

1 Answers  


Does postgres cache queries?

1 Answers  


Is postgresql a database?

1 Answers  


How do I change the default port for postgresql?

1 Answers  


How do I delete a query?

1 Answers  


Categories