Re: Copying data from one table to another - how to specify fields? - Mailing list pgsql-general

On Mar 9, 2011, at 08:47 , Alexander Farber wrote:

> Hello,
>
> I'm using CentOS 5.5 with PostgreSQL 8.4.7 and
> am migrating my site from phpBB 3 to Drupal 7.
>
> I would like to copy these fields from one table:
>
>  select user_id, username, user_email, user_regdate, user_lastvisit
> from phpbb_users where user_id > 50;
>
> into the other (already existing) table:
>
>  select uid, name, mail, created, access from drupal_users;

INSERT INTO drupal_users (uid, name, mail, created, access)
  SELECT user_id, username, user_email, user_regdate, user_lastvisit
    FROM phpbb_users
    WHERE user_id > 50;

<http://www.postgresql.org/docs/9.0/interactive/sql-insert.html>

Michael Glaesemann
michael.glaesemann@myyearbook.com