Error with table that exists but postgres says it doesn't

Started by Chris Williamsabout 27 years ago1 messages
#1Chris Williams
chris_d_williams@itd.sterling.com

I have a table I created and it shows up when I do the \dt from the psql prompt. But when I try to
do a select from it I get the following.

select * from jddattdata;
ERROR: cannot find attribute 1 of relation jddattdata

I haven't inserted any data yet. I tried to drop the table and I get an error also. Any way I can
clean some system table to help me fix this problem.
Thanks
---------
Chris Williams
Sterling Software
Rome, New York
Phone: (315) 336-0500
Email: chris_d_williams@sterling.com