relation does not exist - Mailing list pgsql-admin

From RShepard@hhcmt.com
Subject relation does not exist
Date
Msg-id OF9F6DA17B.732FD8F4-ON872569FC.006479CF@stpetes.org
Whole thread Raw
Responses Re: relation does not exist  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-admin

I am trying to convert a MS SQL database to postgres.  I have done it
this way:

1) use Access -> link to MS SQL
2) install postgress ODBC driver
3) use Access -> copy -> ODBC compliant database.
4) set up the database in postgress
5) do the copy from access.

the file Dx for the table Dx is created in the base/sw_codes database.  the
file contains the data, so it is being copied correctly by access to
postgres..

however I cannot access the table from psql.  I get the following
message:

Welcome to psql, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help on internal slash commands
       \g or terminate with semicolon to execute query
       \q to quit

sw_codes=# select * from Dx;
ERROR:  Relation 'dx' does not exist

sw_codes=# \dt
    List of relations
 Name | Type  |  Owner
------+-------+----------
 Dx   | table | rshepard
(1 row)

can some one help?

postgres v 7.03
odbc v 6.5 (can't find odbc v 7.x)

thanks

bob shepard
rshepard@hhcmt.com





pgsql-admin by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: [HACKERS] Re: v7.1b4 bad performance
Next
From: Maggie Chan
Date:
Subject: lock the database