[OPEN-ILS-DEV] Open-ils-dev Digest, Vol 70, Issue 4

[David Busby]

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 <dkhot at dreamsoftech.com> 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: open-ils-dev-bounces at list.georgialibraries.org
> [mailto:open-ils-dev-bounces at list.georgialibraries.org] On Behalf Of
> open-ils-dev-request at list.georgialibraries.org
> Sent: Wednesday, January 04, 2012 10:30 PM
> To: open-ils-dev at list.georgialibraries.org
> Subject: Open-ils-dev Digest, Vol 70, Issue 3
>
> Send Open-ils-dev mailing list submissions to
>        open-ils-dev at list.georgialibraries.org
>
> 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
>        open-ils-dev-request at list.georgialibraries.org
>
> You can reach the person managing the list at
>        open-ils-dev-owner at list.georgialibraries.org
>
> 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 <jstephenson at mvlc.org>
> Subject: Re: [OPEN-ILS-DEV] No tables in database
> To: open-ils-dev at list.georgialibraries.org
> Message-ID: <20120104085632.24773ay15os2yjs4 at mail.mvlc.org>
> Content-Type: text/plain; charset=ISO-8859-1; DelSp="Yes";
>        format="flowed"
>
> Quoting darshan <dkhot at dreamsoftech.com>:
>
>> 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
> *******************************************