Received: from wallace.ece.rice.edu (root@wallace.ece.rice.edu [128.42.12.154]) by hub.org (8.9.3/8.9.3) with ESMTP id SAA40941 for ; Fri, 27 Aug 1999 18:11:41 -0400 (EDT) (envelope-from reedstrm@wallace.ece.rice.edu) Received: by wallace.ece.rice.edu via sendmail from stdin id (Debian Smail3.2.0.102) for pgsql-sql@postgreSQL.org; Fri, 27 Aug 1999 17:11:40 -0500 (CDT) Date: Fri, 27 Aug 1999 17:11:40 -0500 From: "Ross J. Reedstrom" To: pgsql-sql@postgreSQL.org Subject: Re: [SQL] Newbie dbadmin out of his league Message-ID: <19990827171140.A15338@wallace.ece.rice.edu> References: <3.0.3.32.19990827211232.006f4c40@popmail.dircon.co.uk> <7648.935788758@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 0.95.3i In-Reply-To: <7648.935788758@sss.pgh.pa.us>; from Tom Lane on Fri, Aug 27, 1999 at 05:19:18PM -0400 On Fri, Aug 27, 1999 at 05:19:18PM -0400, Tom Lane wrote: > Tim Pizey writes: > > 2. How do I use COPY? > > > Just create the sequence with the right starting value (one past last > ID being loaded). You can do that before or after the COPY, doesn't > matter. What I always do with sequences that are autocreated for serial types (and so have a start value of 1), after the COPY puts all my data in place: select setval('tablename_field_seq',max(field)) from tablename; Ross -- Ross J. Reedstrom, Ph.D., NSBRI Research Scientist/Programmer Computer and Information Technology Institute Rice University, 6100 S. Main St., Houston, TX 77005