Re: How to use serial variable to insert into muiti-recrods?

From: Richard Huxton <dev(at)archonet(dot)com>
To: hu js <hu(dot)bill2005(at)hotmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: How to use serial variable to insert into muiti-recrods?
Date: 2007-09-06 08:16:29
Message-ID: 46DFB75D.2090105@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

hu js wrote:
> run:
> "CREATE TABLE xxx
> (
> id serial NOT NULL,
> name character varying
> );
> insert into xxx select default values,place_name from air_bui;"

insert into xxx (name) SELECT place_name FROM ...

HTH
--
Richard Huxton
Archonet Ltd

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Jean-David Beyer 2007-09-06 11:45:41 Re: How to use serial variable to insert into muiti-recrods?
Previous Message Milen A. Radev 2007-09-06 07:49:52 Re: How to use serial variable to insert into muiti-recrods?