On Mon, Jan 17, 2005 at 12:36:33PM -0800, Kanu Patel wrote: > I had an employee table with the following columns in it: id, name, address, > phone, payinfo. > I had loaded the data using: "copy employee from 'employee.txt';" command. > I want to get namde of one employee, so I have entered the following command: > select name from employee where id='1'; This returns zero rows.
Is there an employee with id='1'? What data type is the id column? If it's a string type (char, varchar, text) then I wonder if the data has extraneous whitespace. I mentioned this in my original reply, and I asked you to run a query like the following: SELECT '<' || id || '>', name FROM employee WHERE id LIKE '%1%'; Please run that query and look closely at whether there are spaces around the id value. If the query doesn't return what you expect, then please post the query you ran and show the record you expect it to match. It might be useful to see that record as the output of the following command: pg_dump -t employee -aD | grep 'something' where 'something' is a pattern that will match the desired record. -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
