cnxarchive_users_to_csv.sql

COPY (SELECT ROW_NUMBER() OVER (ORDER BY id),
             username,
             '{SSHA}RmBlDXdkdJaQkDsr790+eKaY9xHQdPVNwD/B' AS password_digest, -- ssha hash for "password"
             SUBSTR(title, 0, 255) AS title, -- accounts db uses varchar(255)
             SUBSTR(first_name, 0, 255) AS first_name,
             SUBSTR(last_name, 0, 255) AS last_name,
             SUBSTR(full_name, 0, 255) AS full_name,
             username || '@e-mail-tester.appspotmail.com' AS email_address FROM users) TO STDOUT DELIMITER ',' CSV HEADER;