mad rug wrote:
Yes, that's how Ray said.
"88352" is not the data I have in that entry, it is some plain text
data. This data can be quite large, so I use TEXT instead of CHAR/VARCHAR.
I'm puzzled how can this seem like some unusual situation... I thought
that it was the way pgAdmin returned
I have used text in all my tables in Postgres and have never had a problem
inserting data nor viewing it with PgAdmin. How do you know it isn't a JDBC
issue?
On Wed, Sep 30, 2009 at 3:48 PM, mad rug wrote:
> Yes, that's how Ray said.
>
> "88352" is not the data I have in that entry, it is some p
Applies to PgAdmin 1.10.0, PostGIS (in general)
When working with geodata (using PostGIS in PostgreSQL) its often
neccessary to make joins that are not regular joins (see the example
below), and use all kinds of special processing functions. It is not
possible to enter them in the graphical que
Yes, that's how Ray said.
"88352" is not the data I have in that entry, it is some plain text data.
This data can be quite large, so I use TEXT instead of CHAR/VARCHAR.
I'm puzzled how can this seem like some unusual situation... I thought that
it was the way pgAdmin returned large objects (to av
On 30/09/2009 21:28, Michael Shapiro wrote:
> What is wrong with these results? COL1 has the text value "88352"
I think his point was that this was what he got querying via pgAdmin,
while he got the actual column contents via JDBC.
Ray.
--
What is wrong with these results? COL1 has the text value "88352"
On Wed, Sep 30, 2009 at 2:52 PM, Dave Page wrote:
> [Please keep the list CC'd]
>
> On Wed, Sep 30, 2009 at 8:49 PM, mad rug wrote:
> > Hi
> >
> > This is the definition:
> >
> > CREATE TABLE "TBL"
> > (
> > "ID" bigint NOT NUL
[Please keep the list CC'd]
On Wed, Sep 30, 2009 at 8:49 PM, mad rug wrote:
> Hi
>
> This is the definition:
>
> CREATE TABLE "TBL"
> (
> "ID" bigint NOT NULL,
> "COL1" text NOT NULL,
> "COL2" integer NOT NULL,
> "COL3" character(2) NOT NULL,
> CONSTRAINT "TBL_pkey" PRIMARY KEY ("ID")
>
On Wed, Sep 30, 2009 at 8:40 PM, mad rug wrote:
> Hi
>
> This is a very simple question, but I couldn't google an answer.
> I have some tables with TEXT data type columns and my application can use
> them with no problem; just when I query these columns using pgAdmin, they
> show up as some int id
Hi
This is a very simple question, but I couldn't google an answer.
I have some tables with TEXT data type columns and my application can use
them with no problem; just when I query these columns using pgAdmin, they
show up as some int id. How can I view the actual column content?
I'm using pgAdmi
