| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | Yan Yan Che <yanyan_che(at)yahoo(dot)com(dot)au> |
| Cc: | <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Pls Help me: access problems to tables |
| Date: | 2003-03-14 07:10:57 |
| Message-ID: | 20030313230929.Q76775-100000@megazone23.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Fri, 14 Mar 2003, [iso-8859-1] Yan Yan Che wrote:
>
> then i tried to run another script which basically 'inserts' many
> records to the tables in the database that i've just created. but
> postgres seemed not to allow me to access any relations(tables). i
> tried select * from <relationname> and the <relationname> is always
> 'Not Found'. (But i've just inserted the relation and it can be viewed
> via PgAdmin!!!)
Did you perhaps use mixed case (or upper case) when creating the name?
It's possible that PGAdmin created the table with double quotes around
the name at which point the name used without double quotes won't
match.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mohd Toha Taifor | 2003-03-14 07:20:29 | Re: Is there any procedure to start postgre database server automatically |
| Previous Message | shreedhar | 2003-03-14 07:01:36 | Is there any procedure to start postgre database server automatically |