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
);
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 |