Re: Recursive Arrays 101

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(at)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(at)archidevsys(dot)co(dot)nz <mailto:GavinFlower(at)archidevsys(dot)co(dot)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(dot)klaver(at)aklaver(dot)com