Re: Please help: PHP4/postgres db woes

Danny O'Brien typed this on 03/09/2004 07:45 AM:
>
> My next test was an attempt to manually enter values into the database
> (called "ourdb" for the sake of this test):
>
> ourdb=# INSERT INTO usr (id, fname, lname, login, password, admin_flag,
> client_id) VALUES (4, 'Fred', 'Friendly', 'Fred', 'xxxxx', 'A', 1)
> ourdb-#
>

Typically, you would end your INSERT statement with a ';'

In your example, you do not, otherwise the db would give you back some
sort of response.

> The database did not accept the new information. Why not? More
> questions....
>

-Robby

--
Robby Russell,  |  Sr. Administrator / Lead Programmer
Command Prompt, Inc.   |  http://www.commandprompt.com
rrussell@commandprompt.com | Telephone: (503) 222.2783