Print out all records and fields from a table using console.log

[yoonghm]

I have a table

todo=# \d+ items
                                                    Table "public.items"
 Column |         Type          |                     Modifiers                      | Storage  | Stats target | Description 
--------+-----------------------+----------------------------------------------------+----------+--------------+-------------
 id     | integer               | not null default nextval('items_id_seq'::regclass) | plain    |              | 
 task   | character varying(64) |                                                    | extended |              | 

It has the following records

todo=# select * from items;
 id |     task      
----+---------------
  1 | Eat lunch
  2 | Eat dinner
  3 | Eat breakfast
  4 | Study
  5 | Sleep
  6 | Bath
(6 rows)

How to you print out all records, all columns from the table? I did that but it is not correct:

Items = new PG.Table("items");
var records = Items.select('id', 'task').orderBy('id').fetch();
for (var x in records) {
  console.log(x);
}

which gives

0
1
2
3
4
5

[robfallows]

Items = new PG.Table("items");
var records = Items.select('id', 'task').orderBy('id').fetch();
for (var x in records) {
  console.log(records[x]);
}

or

Items = new PG.Table("items");
var records = Items.select('id', 'task').orderBy('id').fetch();
_.each(records, (row) => {
  console.log(row);
}

[yoonghm]

thanks will try out. should be updated to the document.