Re: crud application please help

On 16/05/2011 03:19, hatem gamal elzanaty wrote:
> hi,
> can you please guide me in a crud application for one table that have
> auto increment serial number for each record can you please give what
> syntax do i have to enter new record without writing manually the id of
> the record through php connection to postgresql if you can send me an
> example for one table with two fields it would be more than enough i
> would appreciate if you gave me a link , book name , tutorial web site

Auto-incrementing columns, or SERIAL types [1]:

http://www.postgresql.org/docs/9.0/static/datatype-numeric.html#DATATYPE-SERIAL

Default values - look for the DEFAULT keyword:

http://www.postgresql.org/docs/9.0/static/sql-createtable.html

[1] Note that SERIAL isn't a real type, but just syntactic sugar that
creates a sequence and sets the column to pull from the sequence by
default. More on sequences:

http://www.postgresql.org/docs/9.0/static/sql-createsequence.html

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod(at)iol(dot)ie