db select count from ws_article_source count -------- 382511 row db ws

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
db=# select count(*) from ws_article_source;
count
--------
382511
(1 row)
db=# \d ws_article_source;
Table "ws_article_source"
Column | Type | Modifiers
----------------+-------------------+------------------------------------------------------------------------
title | character varying | not null
article_source | text |
article_xml | text |
article_id | integer | not null default nextval('ws_article_source_article_id_seq'::regclass)
Indexes:
"ws_article_source_pkey" PRIMARY KEY, btree (article_id)
"ws_article_source_lower_title_ind" UNIQUE, btree (lower(title::text))
"ws_article_source_length_xml_ind" btree (length(article_xml))