How to fetch TEXT column value from postgresql
postgresql
Solution
Following helped us:
select convert_from(loread(lo_open(value::int, x'40000'::int), x'40000'::int), 'UTF8') from t_field;
where `value` is field, which contains `TEXT`, and t_field is obviously name of table.
Problem
I have a the following simple table in postgreSQL: ``` CREATE TABLE data ( id bigint NOT NULL, text_column text, ); ``` The values of the text_column , as I see them in the phpPgAdmin web site, are numbers (long). As I read, postgreSQL keeps a pointer to the actual data. How can I fetch the actual string value of the text_column? Doing: ``` select text_column from data ``` returns numbers... Thanks