Postgresql 9.0.5 on Red Hat/Linux
In the table described below, the report xml contains xml (DOCUMENT) that ranges in size from 31KB to 518KB. When I do ‘select reportxml from somereportxml where reportkey = ‘silly’;’ the terminal screen appears blank with ‘more’ displayed on the bottom. The data is in the database – verified using EMS SQL Studio for PostgreSQL – but does not show up using pgadmin3 or typing the Select statement from the terminal screen. Any ideas?
CREATE TABLE somereportxml
(
reportkey character varying(36) NOT NULL DEFAULT uuid_generate_v1(),
objectname character varying(200) NOT NULL,
reportxml xml NOT NULL,
recordtimestamp timestamp(2) with time zone NOT NULL DEFAULT now(),
CONSTRAINT pkey_somereportxml PRIMARY KEY (reportkey )
)
WITH (
OIDS=FALSE
);
Paula Price