From: | Michael Davis <mdavis(at)sevainc(dot)com> |
---|---|
To: | "'RShepard(at)hhcmt(dot)com'" <RShepard(at)hhcmt(dot)com>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | RE: relation does not exist |
Date: | 2001-02-26 18:02:43 |
Message-ID: | 01C09FE3.A9119BF0.mdavis@sevainc.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Try:
select * from "Dx";
-----Original Message-----
From: RShepard(at)hhcmt(dot)com [SMTP:RShepard(at)hhcmt(dot)com]
Sent: Friday, February 23, 2001 11:17 AM
To: pgsql-admin(at)postgresql(dot)org
Subject: relation does not exist
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(at)hhcmt(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Derek Neighbors | 2001-02-26 18:46:03 | CHAR vs VARCHAR |
Previous Message | lbottorff | 2001-02-26 17:41:33 | Default not triggering |