INSERT INTO TABLE_B  SELECT * FROM TABLE_A; burda alanları aynı olan tablodan tabloya aktarım olayı.

INSERT INTO TABLE_B (NAME, PHONE) SELECT NAME, PHONE FROM TABLE_A; Table A dan Name ve phone alınıp Table B ye eklenir.

Commit unutmayalım.

This entry was posted on Tuesday, April 22nd, 2008 at 6:26 am and is filed under pl/pgsql. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.