Hi A little more research. I accessed the problem table as a remote connection using PGAdmin.I selected the cell that shows as being null and copied and pasted the contents into Word.
The geom IS there.Using this method the geom is also present, but not visible, in the table I am accessing as a local connection. This is the remote database which I dumped and then restored as a local.
These fields are not only not visible but they return null when I do a simple select query.
I could really do with some suggestions. Bob-----Original Message----- From: Adrian Klaver
Sent: Thursday, April 21, 2011 7:22 PM To: pgsql-general@xxxxxxxxxxxxxx Cc: Bob Pawley ; Scott Marlowe Subject: Re: Different views of remote server On Thursday, April 21, 2011 9:24:57 am Bob Pawley wrote:
Hi Scott According to NSAuditor(www.nsauditor.com) there is only one server with port 5432. When I enter information into the remote database it shows up on the same database that has this problem. How do I determine my 'connection credentials'?
In pgAdmin they will be in the server properties. Look to see if you are connecting to a port other than 5432.
-- Adrian Klaver adrian.klaver@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-general
-- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Programming PHP] [Kernel Newbies] [PHP Classes] [Find Someone Nice] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]