Hi All,
Thanks for the Help. We have got the database table named as "usr" but didn't find the actual name of variable which we can use in template file that is "hold_notification_template.example". Instead of that we found the columns that is 'day_phone', 'evening_phone', 'other_phone' which we cannot use as variable in template file to send patron's phone number in mail. Please help us to retrieve actual variable name that can be used in template file. Thanks Darshan Khot -----Original Message----- From: David Busby [mailto:[email protected]] Sent: 05 January 2012 14:28 To: Evergreen Development Discussion List Cc: [email protected] Subject: Re: [OPEN-ILS-DEV] Open-ils-dev Digest, Vol 70, Issue 4 Darshan, The tables in Evergreen are contained within a Schema in PostgreSQL, so there are simply no tables in the public schema (that which you sent a picture of). If you issue the command: \dn You will see a list of these schema name-spaces, mine looks like: ---- (postgres@[local]:5432) [evergreen] > \dn List of schemas Name | Owner -----------------+------------ acq | openils-su action | openils-su action_trigger | openils-su actor | openils-su asset | openils-su auditor | openils-su authority | openils-su biblio | openils-su booking | openils-su config | openils-su container | openils-su evergreen | openils-su extend_reporter | openils-su m_demo | openils-su metabib | openils-su migration_tools | openils-su money | openils-su offline | openils-su permission | openils-su public | postgres query | openils-su reporter | openils-su search | openils-su serial | openils-su staging | openils-su stats | openils-su unapi | openils-su vandelay | openils-su (28 rows) --- Then within each Schema is a set of tables, my current favourite thing to play with is action_triggers, so lets look there: --- (postgres@[local]:5432) [evergreen] > \dt action_trigger.* List of relations Schema | Name | Type | Owner ----------------+------------------+-------+------------ action_trigger | cleanup | table | openils-su action_trigger | collector | table | openils-su action_trigger | environment | table | openils-su action_trigger | event | table | openils-su action_trigger | event_definition | table | openils-su action_trigger | event_output | table | openils-su action_trigger | event_params | table | openils-su action_trigger | hook | table | openils-su action_trigger | reactor | table | openils-su action_trigger | validator | table | openils-su (10 rows) --- So, 10 tables in that schema. Notice that tables are fully qualified, like action_trigger.cleanup then a column would be action_trigger.cleanup.id. -- David Busby Managing Director Edoceo, Inc. http://edoceo.com/ 206.282.6500 On Wed, Jan 4, 2012 at 11:37 PM, darshan <[email protected]> wrote: > Hi, > > We even call database evergreen , then to No tables were found. > Please refer the Attachment and Guide us. > > Thanks > Darshan Khot > ---------------------------------------------------------------------- > ------ > ---------------------------------------------------------------------- > ------ > ---------------------------------------------------------------------- > ------ > --------------------------- > -----Original Message----- > From: [email protected] > [mailto:[email protected]] On Behalf Of > [email protected] > Sent: Wednesday, January 04, 2012 10:30 PM > To: [email protected] > Subject: Open-ils-dev Digest, Vol 70, Issue 3 > > Send Open-ils-dev mailing list submissions to > [email protected] > > To subscribe or unsubscribe via the World Wide Web, visit > > http://libmail.georgialibraries.org/mailman/listinfo/open-ils-dev > or, via email, send a message with subject or body 'help' to > [email protected] > > You can reach the person managing the list at > [email protected] > > When replying, please edit your Subject line so it is more specific > than > "Re: Contents of Open-ils-dev digest..." > > > Today's Topics: > > 1. Re: No tables in database (Jason Stephenson) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Wed, 04 Jan 2012 08:56:32 -0500 > From: Jason Stephenson <[email protected]> > Subject: Re: [OPEN-ILS-DEV] No tables in database > To: [email protected] > Message-ID: <[email protected]> > Content-Type: text/plain; charset=ISO-8859-1; DelSp="Yes"; > format="flowed" > > Quoting darshan <[email protected]>: > >> Hi, >> >> I checked in database but I couldn't find table that you mention. In >> fact there was no single table in database. Please see attached >> screenshot and guide me if I am referring wrong database. > > You are looking at the wrong database. When you run psql add -d > evergreen on the command line, like so: > > psql -d evergreen > > That should get you into the right database. > > Jason > > >> >> Thanks >> Darshan > > > > End of Open-ils-dev Digest, Vol 70, Issue 3 > *******************************************
