Re: Copy column contents - Mailing list pgsql-php

Hi,

>        I have a database table with 8 fields and i want to add a new
>column and copy the contents of one column to new column. if i try using
>select and insert number of rows is duplicating and insertion is going to
>end. how do i insert that contents to same row.

Almost right, use update instead of insert:

UPDATE table SET name = title;

HTH,
Chris.