You can explicitly set the values in the nextval() column. Nextval() is
only a default.You can also query and manipulate the sequence number
after it is created.(using curval() nextval() setval()).
Some developers do not use the auto increment behavior.They will do
something like:
That does the job. Thank you.
Another related question: I need to use /i file to import my
current database into postgres. It seems that I have to use
nextval(...) when doing an insert. Is it possible to insert a
row without having to use 'nextval()'?
David Hartwig wrote:
>
> Each PostgreSQ
Each PostgreSQL table has a, system assigned, oid (object ID) column which
is useful for uniquely identifying rows. Users have vertually no control
over it value.
There is also:
CREATE TABLE foo (
aiserial primary key,
bar integer
);
which is a short cut in the pa
> Subject: Bad column offset ?
>
> I am porting all my applications from mSQL to PostgreSQL. I am trying to
> access the results from a query to PostgreSQL issued from within PHP3.
>
> I connect with no problems to the database, and I can even get the number of
> elements returned by my query like
How do I set up a column as auto increment? I have looked
everywhere for the postgres equivalent ROWID as in Oracle.
--
Robert Williams [EMAIL PROTECTED]
Jarob Consulting [EMAIL PROTECTED]
Provo, Utah [EMAIL PROTECTED]
begin:vcard
n:Williams;Robert
x-mozilla-html:
Hello
I wish thanx Evan Howarth for replay on my first question.
I have another question. Does tables has OID ? And how to get it ?
Regards,
Sergey
