diff options
Diffstat (limited to 'tjp.sh')
-rwxr-xr-x | tjp.sh | 6 |
1 files changed, 5 insertions, 1 deletions
@@ -39,10 +39,14 @@ list_personal_entries() { } # Function to select all MOD entries +# list_MOD_entries() { +# psql -h "$HOST" -U "$USER" -d "$DB" -c "\x" -c "SELECT * FROM journal_entries WHERE type = 1;" +# } list_MOD_entries() { - psql -h "$HOST" -U "$USER" -d "$DB" -c "\x" -c "SELECT * FROM journal_entries WHERE type = 1;" + psql -h "$HOST" -U "$USER" -d "$DB" -c "\x" -c "SELECT id, date_added, entry, comment, meeting_id FROM journal_entries WHERE type = 1;" } + # Function to list all MOD contacts list_MOD_contacts() { psql -h "$HOST" -U "$USER" -d "$DB_CONTACTS" -c "SELECT id, first_name, last_name, email, phone, contact_comments FROM contacts WHERE contact_type = 3;" |