I had trouble viewing the result of the folllowing query (showing empty for each entry returned):
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.
-- 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
);