[OPEN-ILS-DEV] cstore problem

[Dan Scott]

Close, but \dt won't work for these purposes.

\dn is what you want to use to display all of the schemas, and you
should see something like this:


        List of schemas
        Name        |  Owner
--------------------+----------
 action             | postgres
 actor              | postgres
 asset              | postgres
 auditor            | postgres
 authority          | postgres
 biblio             | postgres
 config             | postgres
 container          | postgres
 information_schema | postgres
 metabib            | postgres
 money              | postgres
 offline            | postgres
 permission         | postgres
 pg_catalog         | postgres
 pg_toast           | postgres
 public             | postgres
 reporter           | postgres
 stats              | postgres
(18 rows)

Dan

On 15/05/07, Don Hamilton <dhamilton at wlu.ca> wrote:
>
>
> Hi again... sorry about not responding to the list, Don... Me bad, again!..
>
> Anyway, \dt also only shows the 4 tables that hennie reported.
> I did find ~/Evergreen/Open-ILS/src/sql/Pg/build-db.sh, and
> ran it, entering the password several times, and watching output that looked
> like it was working... but still no tables show with a \dt.
>
> don
>
> >>> don.mcmorris at gmail.com 5/15/2007 2:15 AM >>>
>
> My bad guys! \z is privileges.  Instead, run \dt.  According to the
> manual, this should show the tables.
>
> --Don
>
> On 5/15/07, Hennie Rautenbach <hennie at sabinet.co.za> wrote:
> > Don McMorris wrote:
> > > First, I want to make sure the PostgreSQL server is functioning right
> > > and that the evergreen database is populated properly.  To do this:
> > > root# su postgres -c "psql -h tamarak -p 5432 -U evergreen evergreen"
> > > evergreen> \z
> > > evergreen> \q
> > > root#
> > Thought I'd do the same:
> >
> > opensrf at leo:~$ psql -h leo.sabinet.co.za -p 5432 -U postgres evergreen
> > Password for user postgres:
> > Welcome to psql 8.1.8, the PostgreSQL interactive terminal.
> >
> > Type:  \copyright for distribution terms
> >        \h for help with SQL commands
> >        \? for help with psql commands
> >        \g or terminate with semicolon to execute query
> >        \q to quit
> >
> > SSL connection (cipher: DHE-RSA-AES256-SHA, bits: 256)
> >
> > evergreen=# \z
> >     Access privileges for database "evergreen"
> >  Schema |     Name     | Type  | Access privileges
> > --------+--------------+-------+-------------------
> >  public | pg_ts_cfg    | table |
> >  public | pg_ts_cfgmap | table |
> >  public | pg_ts_dict   | table |
> >  public | pg_ts_parser | table |
> > (4 rows)
> >
> > evergreen=# \q
> > opensrf at leo:~$
> >
> > Hennie
> >
> >
> >
> --------------------------------------------------------------------------------
> >
> > This transmission is for the intended addressee only and is confidential
> > information. If you have received this transmission in error, please
> > delete it and notify the sender. The contents of this e-mail are the
> > opinion of the writer only and are not endorsed by Sabinet Online
> > Limited unless expressly stated otherwise.
> >
> --------------------------------------------------------------------------------
> >
>


-- 
Dan Scott
Laurentian University