pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
phpPgAdmin users
2+ messages / 2 participants
[nested] [flat]

* phpPgAdmin users
@ 2001-01-12 00:35  Julio Cuz, Jr. <jcuz@rccd.cc.ca.us>
  0 siblings, 1 reply; 2+ messages in thread

From: Julio Cuz, Jr. @ 2001-01-12 00:35 UTC (permalink / raw)
  To: pgsql-php

Hi--

I'm using phppgadmin for pgsql, how do i create a field called (i.e. ID) 
that INCREASES by ONE AUTOMATICALLY each time a record is added?  I want 
pgsql to add it automatically.

Thanks.

Julio Cuz, Jr.
Riverside Community College
jcuz@rccd.cc.ca.us




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: phpPgAdmin users
@ 2001-01-12 01:22  Louis Bertrand <louis@bertrandtech.on.ca>
  parent: Julio Cuz, Jr. <jcuz@rccd.cc.ca.us>
  0 siblings, 0 replies; 2+ messages in thread

From: Louis Bertrand @ 2001-01-12 01:22 UTC (permalink / raw)
  To: Julio Cuz, Jr. <jcuz@rccd.cc.ca.us>; +Cc: pgsql-php

Create a column with type SERIAL in the table, or if you want to have
programmatic access to the number while you're handling the update, use a
sequence.

Don't take this as a flame, but if you're doing a lot of work with
PostgreSQL, you really ought to buy the book. No conflict of interest
here, just another satisfied reader...

Ciao
 --Louis  <louis@bertrandtech.on.ca> 


On Thu, 11 Jan 2001, Julio Cuz, Jr. wrote:

> Hi--
> 
> I'm using phppgadmin for pgsql, how do i create a field called (i.e. ID) 
> that INCREASES by ONE AUTOMATICALLY each time a record is added?  I want 
> pgsql to add it automatically.
> 
> Thanks.
> 
> Julio Cuz, Jr.
> Riverside Community College
> jcuz@rccd.cc.ca.us
> 
> 




^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2001-01-12 01:22 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-01-12 00:35 phpPgAdmin users Julio Cuz, Jr. <jcuz@rccd.cc.ca.us>
2001-01-12 01:22 ` Louis Bertrand <louis@bertrandtech.on.ca>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox