From: | Paula Price <paula(dot)price(at)issinc(dot)com> |
---|---|
To: | "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
Subject: | large XML data type appears empty when doing a select |
Date: | 2012-01-12 18:58:00 |
Message-ID: | 32E8EAEC23EF1947BEC2FA1E4BFBADCD1C214CE912@VA3DIAXVS901.RED001.local |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Browder | 2012-01-13 16:24:16 | Security Best Practices: Is This Reasonable? |
Previous Message | 2M Data Systems | 2012-01-12 01:15:00 | Compiling libpq with Borland bcc32 |