Re: How to append records into a file which has serial

From: James Long <james_mapson(at)umpquanet(dot)com>
To: george young <gry(at)ll(dot)mit(dot)edu>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: How to append records into a file which has serial
Date: 2006-04-09 06:27:07
Message-ID: 20060409062707.GA78829@ns.museum.rain.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

> This worked for me:
>
> newschm3=> create table foo(x text,y text,a serial);

I think it just dawned on me -- I have to put the serial ID at
the end of the table structure, don't I? So that the fields
correspond one-to-one, until the temp runs out of columns
where the master table has the SERIAL field.

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Mike 2006-04-09 12:27:47 Re: PostgreSQL a slow DB?
Previous Message James Long 2006-04-09 06:22:29 Re: How to append records into a file which has serial