This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
postgresql [2013/08/25 23:24] steve created |
postgresql [2013/08/25 23:30] steve |
||
---|---|---|---|
Line 2: | Line 2: | ||
== Display a chapter == | == Display a chapter == | ||
+ | |||
+ | |||
<code> | <code> | ||
- | psql -q -c "select scripture_text from scriptures where book_title = 'Isaiah' and chapter_number = 48 order by verse_id;" -At | + | psql -q -At -c "select scripture_text from scriptures where book_title = 'Isaiah' and chapter_number = 48 order by verse_id;" |
</code> | </code> | ||
+ | |||
+ | Same, but with formatting ready for wiki: | ||
+ | |||
+ | psql -q -At -F '' -c "SELECT ' -', scripture_text .." |