Re: Recursive Arrays 101 - Mailing list pgsql-general

On 10/26/2015 03:57 PM, David Blomstrom wrote:
> When I type in /l, it just says "database Postgres," even though I can
> see TWO databases in pgAdmin III. When I type in /dt, it says Username
> [postgres].

Huh. It should be \l and \dt
Step us through what you are doing, using cut and paste directly from
the terminal.

So something like:

aklaver@panda:~> psql -d test -U aklaver -h localhost

psql (9.4.4)
SSL connection (protocol: TLSv1.2, cipher: ECDHE-RSA-AES256-GCM-SHA384,
bits: 256, compression: off)
Type "help" for help.

test=>

test=> \l
                                       List of databases
       Name       |   Owner    | Encoding |   Collate   |    Ctype    |
   Access privileges
-----------------+------------+----------+-------------+-------------+-----------------------
  business_app    | app_admin  | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
  hplc            | hplc_admin | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
  postgres        | postgres   | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
  production      | postgres   | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
  template0       | postgres   | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
=c/postgres          +
                  |            |          |             |             |
postgres=CTc/postgres
  template1       | postgres   | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
=c/postgres          +
                  |            |          |             |             |
postgres=CTc/postgres
  test            | postgres   | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
  test_hplc       | hplc_admin | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
  test_production | postgres   | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
  track_stocks    | aklaver    | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
(10 rows)

test=> \dt
             List of relations
  Schema |     Name     | Type  |  Owner
--------+--------------+-------+----------
  public | app_sessions | table | postgres
  public | app_users    | table | postgres
  public | cp_test      | table | aklaver
  public | data         | table | aklaver
  public | date_test    | table | postgres
  public | excl_test    | table | aklaver
  public | fk_rel       | table | postgres
  public | foo          | table | aklaver
  public | inet_test    | table | postgres
  public | json_test    | table | postgres
  public | lat_long     | table | postgres
  public | orig_test    | table | aklaver
  public | pk_rel       | table | postgres
  public | pr_test      | table | aklaver
  public | rowtype_test | table | aklaver
  public | sub_item     | table | postgres
  public | ts_test      | table | postgres
  public | users        | table | aklaver


>
> On Mon, Oct 26, 2015 at 3:40 PM, Gavin Flower
> <GavinFlower@archidevsys.co.nz <mailto:GavinFlower@archidevsys.co.nz>>
> wrote:
>
>     On 27/10/15 11:18, David Blomstrom wrote:
>     [...]
>
>         CREATE DATABASE GeoZoo2
>
>     [...]
>
>     Would strongly advise NOT using capital letters in names of
>     databases in pg!
>
>
>
>
> --
> David Blomstrom
> Writer & Web Designer (Mac, M$ & Linux)
> www.geobop.org <http://www.geobop.org>


--
Adrian Klaver
adrian.klaver@aklaver.com