Skip site navigation (1) Skip section navigation (2)

Re: Need a sample Postgre SQL script

From: Richard Huxton <dev(at)archonet(dot)com>
To: Dhanushka Samarakoon <dhanu80(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Need a sample Postgre SQL script
Date: 2008-07-01 14:42:48
Message-ID: 486A4268.3080107@archonet.com (view raw or flat)
Thread:
Lists: pgsql-sql
Dhanushka Samarakoon wrote:
> Hi All,
> 
> I'm kind of new to Postgre and I need some advice.

No problem. It's PostgreSQL or Postgres by the way.

> I have the following table.
> metadata (value:integer , field:integer , mydate:text)
> 
> given below is a sample record from that.
> ( 2 , 16 , Augest 2009)
> 
> I need a script that will read the above table and for each such row it will
> insert two rows as below.
> 
> ( 2 , 91 , Augest )
> ( 2 , 86 , 2009 )
> 
> 16, 91 and 86 are static values. *value and field together* creates the
> primary key.

CREATE TEMP TABLE staticfields (f integer);
INSERT INTO staticfields VALUES (91);
INSERT INTO staticfields VALUES (86);

INSERT INTO metadata (value, field, mydate)
SELECT value, f, mydate
FROM metadata, staticfields;

-- 
   Richard Huxton
   Archonet Ltd

In response to

Responses

pgsql-sql by date

Next:From: Dhanushka SamarakoonDate: 2008-07-01 14:53:02
Subject: Re: Need a sample Postgre SQL script
Previous:From: Dhanushka SamarakoonDate: 2008-07-01 14:31:54
Subject: Need a sample Postgre SQL script

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group