[OPEN-ILS-DEV] cstore problem

[Bill Ott]

\dt *.*

This will show all schemas and all tables within.


Dan Scott said the following on 05/15/2007 07:26 AM:
> 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.
>> >
>> -------------------------------------------------------------------------------- 
>>
>> >
>>
>
>