By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,264 Members | 1,277 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,264 IT Pros & Developers. It's quick & easy.

a doubt in database restoring?

P: 34
Hi all,
in pgsql,
while restoring the data using \i option,
i am getting sometimes..as
INSERT 0 1
INSERT 0 1
INSERT 0 1
and sometimes.... as

INSERT 18890 1
INSERT 18891 1
INSERT 18892 1
INSERT 18893 1
INSERT 18894 1
INSERT 18895 1
what does the above digits refers to????????????
any help will be gladly accepted??????
Nov 4 '08 #1
Share this Question
Share on Google+
2 Replies


Expert 100+
P: 700
Second digit is a number if rows that INSERT starement put into table.
Fist number is a row id (called in postgres 'oid'), it's uniqe row identifier. If table has been created with option 'with oids' (or such option was setting in postgresql.conf file) then every row in a table has such unique identifier (that identifier is displayed after INSERT statement) if not rows didn't have oid's and INSERT displey 0.
Is is clear (it may not because of my english :) )?
Nov 4 '08 #2

P: 34
Thank you for your keen interest.......
Nov 5 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.