[ale] postgresql

[esoteric at 3times25.net (Geoffrey)]

David Hamm wrote:
> Just beginning  to work with postgresql and can't figure this one
> out. I a simple name and address table called companies.  When
> "select * from companies" all records are listed.  But when I try to
> use a where clause I get an "Attribute not found" error.  Here is the
> query "select * from companies where st like ga" which returns
> "Attribute st nof found". I've also tried using this query "select *
> from companies where companies.st like 'ga'" and it returns the same
> error.  And st is one of the fields.  Any suggestions?

Can you post the header output from the 'select * from companies' ?

what does \d companies return from psql?

-- 
Until later, Geoffrey	esoteric at 3times25.net

Building secure systems inspite of Microsoft