Postgres Pro
Downloads
Home   >   mailing lists

Thread: newbie question - INSERT

newbie question - INSERT

From
"Cefull Lo"
Date:
When I type INSERT INTO friend
VALUES ('', '', '');
it returns
INSERT 19748 1

what means of 19748 and 1?

Re: newbie question - INSERT

From
"Dominic J. Eidson"
Date:
On Tue, 10 Apr 2001, Cefull Lo wrote:

> When I type INSERT INTO friend
> VALUES ('', '', '');
> it returns
> INSERT 19748 1
>
> what means of 19748 and 1?

19748 is the OID of that record, and 1 means one record was inserted.

For information on OID's, look in the documentation.


--
Dominic J. Eidson
                                        "Baruk Khazad! Khazad ai-menu!" - Gimli
-------------------------------------------------------------------------------
http://www.the-infinite.org/              http://www.the-infinite.org/~dominic/

Re: newbie question - INSERT

From
Joel Burton
Date:
On Tue, 10 Apr 2001, Cefull Lo wrote:

> When I type INSERT INTO friend
> VALUES ('', '', '');
> it returns
> INSERT 19748 1
>
> what means of 19748 and 1?

It's the OID, a unique idenifier for everything in the database.
Read the Momjian book on the website -- it explains this very well.

--
Joel Burton   <jburton@scw.org>
Director of Information Systems, Support Center of Washington

RE: newbie question - INSERT

From
"Jeff Fitzmyers"
Date:
19748 is the Object ID (OID) The first ~17,000 OID's are reserved for
the system.

1 is the number of inserted rows.

Jeff

>When I type INSERT INTO friend
>VALUES ('', '', '');
>it returns
>INSERT 19748 1

>what means of 19748 and 1?