Re: Recursive Arrays 101
От | Adrian Klaver |
---|---|
Тема | Re: Recursive Arrays 101 |
Дата | |
Msg-id | 562EB2C6.3080303@aklaver.com обсуждение исходный текст |
Ответ на | Re: Recursive Arrays 101 (David Blomstrom <david.blomstrom@gmail.com>) |
Ответы |
Re: Recursive Arrays 101
|
Список | 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
В списке pgsql-general по дате отправления: