Worked perfectly.
Thanks Richard.
On Tue, Jul 1, 2008 at 10:17 AM, Richard Huxton <[EMAIL PROTECTED]> wrote:
> Dhanushka Samarakoon wrote:
>
>> Thanks for the reply.
>> But one problem I have is I need to loop through all the rows in the table
>> and in each itera
, Richard Huxton <[EMAIL PROTECTED]> wrote:
> 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
Hi All,
I'm kind of new to Postgre and I need some advice.
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
