Postgres Pro
Downloads
Home   >   mailing lists

Re: newbie question - INSERT - Mailing list pgsql-general

From Joel Burton
Subject Re: newbie question - INSERT
Date
Msg-id Pine.LNX.4.21.0104102214090.31213-100000@olympus.scw.org
Whole thread Raw
In response to newbie question - INSERT  ("Cefull Lo" <cefull_lo@hotmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Joel Burton
Date:
Subject: Re: Speaking of Indexing... (Text indexing)
Next
From: Joel Burton
Date:
Subject: Re: COPY from file to table containing unique index