relation does not exist
От | RShepard@hhcmt.com |
---|---|
Тема | relation does not exist |
Дата | |
Msg-id | OF9F6DA17B.732FD8F4-ON872569FC.006479CF@stpetes.org обсуждение исходный текст |
Ответы |
Re: relation does not exist
|
Список | 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 по дате отправления: