atlasdb=# select * from test_tab ; id | name | e_mail | d_id ----+---------------+----------------------+------ 1 | hemny | hemny@qq.com | 10 2 | hemny_pg2 | hemny_pg2@qq.com | 10 3 | hemny_pg2_new | hemny_pg2_new@qq.com | 10 (3 rows) atlasdb=#