Обсуждение: 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@hhcmt.com

Try select * from "Dx";
If you want to keep case (as opposed to the normal
lower-casing) you'll need to double quote the name.


On Fri, 23 Feb 2001 RShepard@hhcmt.com wrote:

>
>
> 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
>
>
>
>

Try:
    select * from "Dx";




-----Original Message-----
From:    RShepard@hhcmt.com [SMTP:RShepard@hhcmt.com]
Sent:    Friday, February 23, 2001 11:17 AM
To:    pgsql-admin@postgresql.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@hhcmt.com