[OPEN-ILS-DEV] cstore problem

[Don McMorris]

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.
> --------------------------------------------------------------------------------
>