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@xxxxxxxxxxxxxxxxx <mailto:GavinFlower@xxxxxxxxxxxxxxxxx>>
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@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
