large XML data type appears empty when doing a select

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

Responses

Browse pgsql-novice by date

  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