select * not working

[doddo]

Hi, ive exported some tables from Access into Postgresql. When i list them using
select * from pg_tables they are visible
however when i perform select * on the table I get the following error:

Relation 'tablename' does not exist

any ideas?

thanks

 

[teroy]

hi doddo...at the psql terminal have u tried to type
select * from

and then type in the first few letters of the table then hit tab..and see if it completes the table name for you.. ?

 

[Guest_imported]

Exporting UPPER CASE tables/fields name may have problems.

You need to change all tables & fields name in MS Access before exporting them.

If you can't drop the problem table, use pgaccess.


Sunny Tsang
852-2510-1111