Fwd: viewing text column in search result

From: Yuan Luo <yuan(dot)hypnos(dot)luo(at)gmail(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: Fwd: viewing text column in search result
Date: 2014-07-07 17:59:57
Message-ID: CAMY509nfogPhhqUMGPgNHePRvKi8AK4KeQNdEo6icW-fqrHcoA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hi,
I had trouble viewing the result of the folllowing query (showing empty for
each entry returned):
select text from noteevents where subject_id=21122;
This only appears under pgadmin, text terminal works fine. Table creation
command as follow. Would you please help me out? Am using pgadmin 1.16.1.

Best,
Yuan

-- Table: noteevents

-- DROP TABLE noteevents;

CREATE TABLE noteevents
(
subject_id integer NOT NULL,
hadm_id integer,
icustay_id integer,
elemid integer,
charttime timestamp without time zone NOT NULL,
realtime timestamp without time zone,
cgid integer,
correction character(1),
cuid integer,
category character varying(26),
title character varying(255),
text text,
exam_name character varying(100),
patient_info character varying(4000),
CONSTRAINT noteeven_fk_adm FOREIGN KEY (hadm_id)
REFERENCES admissions (hadm_id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION DEFERRABLE INITIALLY
IMMEDIATE,
CONSTRAINT noteeven_fk_d_caregi FOREIGN KEY (cgid)
REFERENCES d_caregivers (cgid) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION DEFERRABLE INITIALLY
IMMEDIATE,
CONSTRAINT noteeven_fk_d_careun FOREIGN KEY (cuid)
REFERENCES d_careunits (cuid) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION DEFERRABLE INITIALLY
IMMEDIATE,
CONSTRAINT noteeven_fk_d_patien FOREIGN KEY (subject_id)
REFERENCES d_patients (subject_id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION DEFERRABLE INITIALLY
IMMEDIATE,
CONSTRAINT noteeven_fk_icustay FOREIGN KEY (icustay_id)
REFERENCES icustayevents (icustay_id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION DEFERRABLE INITIALLY IMMEDIATE
)
WITH (
OIDS=FALSE
);

Browse pgadmin-support by date

  From Date Subject
Next Message Enrico Maria Crisostomo 2014-07-07 22:04:16 pgAdmin3 @1.18.1_1 UI problems
Previous Message Alexander Yerenkow 2014-07-07 10:21:00 Bug in UI