Skip site navigation (1) Skip section navigation (2)

Re: Problem selecting data

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "Garry Rothert" <garry(dot)rothert(at)dph(dot)ab(dot)ca>,<pgadmin-support(at)postgresql(dot)org>
Subject: Re: Problem selecting data
Date: 2003-02-08 20:14:45
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgadmin-support

> -----Original Message-----
> From: Garry Rothert [mailto:garry(dot)rothert(at)dph(dot)ab(dot)ca] 
> Sent: 07 February 2003 15:36
> To: pgadmin-support(at)postgresql(dot)org
> Subject: [pgadmin-support] Problem selecting data
> Hi
> I've migrated an access database into PostgreSQL using the 
> migration. Everything 
> seems to have worked, but I can't see the tables in the 
> PGADMIN tree. Also when I try 
> and select the data I get the following. 

Hi Garry,

What do you see in the tree?

> ERROR: Relation "tablename" does not exist.

Did the tables have mixed case names, or odd characters (such as spaces)
in them? If so, try double quoting their names in your SQL.
Alternatively, rerun the migration with the option to shift the names to
lower case switched on (it's on the first page).
Regards, Dave

pgadmin-support by date

Next:From: Nick KellyDate: 2003-02-08 23:04:49
Subject: configure: error: no acceptable C compiler found in $PATH
Previous:From: Garry RothertDate: 2003-02-07 15:35:47
Subject: Problem selecting data

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group