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; I've read http://www.postgresql.org/docs/8.4/static/sql-selectinto.html and few more docs but don't understand, how could I specify the fields correspondence (i.e. phpbb_users.user_id -> drupal_users.uid) Also the target table exists already, has some records already and has more fields than specified in my select statement above. Thank you Alex -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
