Re: Getting started - pgadmin3

On 10/03/16 06:58, Sherrie Kubis wrote:
>
> Hello. I am very new to postgresql, just getting started by hands-on.
>
> I have postgres installed and a database running, also have pgadmin3
> installed.
>
> When I startup pgadmin I get the following message, but the app
> continues to open.
>
> 11:31:50 AM: Error: can't open file '/pgadmin3.lng' (error 2: No such
> file or directory)
>
> I have the file pgadmin3.lng in the folder
>
> */postgres/pgAdmin3/share/pgadmin3/i18n*
>
> [postgres(at)bkvlnxtest01 i18n]$ ls
>
> total 92
>
> drwxr-xr-x 12 root daemon 4096 Mar 8 14:37 ./
>
> drwxr-xr-x 6 root daemon 4096 Mar 8 14:37 ../
>
> drwxr-xr-x 2 root daemon 4096 Mar 8 14:37 ca_ES/
>
> drwxr-xr-x 2 root daemon 4096 Mar 8 14:37 cs_CZ/
>
> drwxr-xr-x 2 root daemon 4096 Mar 8 14:37 de_DE/
>
> drwxr-xr-x 2 root daemon 4096 Mar 8 14:37 fr_FR/
>
> drwxr-xr-x 2 root daemon 4096 Mar 8 14:37 ja_JP/
>
> drwxr-xr-x 2 root daemon 4096 Mar 8 14:37 lv_LV/
>
> -rw-r--r-- 1 root daemon 1684 Feb 8 23:18 *pgadmin3.lng*
>
> -rw-r--r-- 1 root daemon 35984 Feb 8 23:18 pg_settings.csv
>
> drwxr-xr-x 2 root daemon 4096 Mar 8 14:37 pl_PL/
>
> drwxr-xr-x 2 root daemon 4096 Mar 8 14:37 ru_RU/
>
> drwxr-xr-x 2 root daemon 4096 Mar 8 14:37 sr_RS/
>
> -rw-r--r-- 1 root daemon 420 Feb 8 23:18 wxstd.mo
>
> drwxr-xr-x 2 root daemon 4096 Mar 8 14:37 zh_CN/
>
> *********************************************************
>
> Sherrie Kubis
>
> Sr. Oracle DBA
>
> Information Technology Bureau
>
> Southwest Florida Water Management District
>
> 2379 Broad Street
>
> Brooksville, FL 34604-6899
>
> 352.796.7211 x4033
>
> sherrie(dot)kubis(at)swfwmd(dot)state(dot)fl(dot)us <mailto:steve(dot)dicks(at)swfwmd(dot)state(dot)fl(dot)us>
>
> Please take a moment to answer a few questions
> <https://www.surveymonkey.com/s/ITB-SWFWMD> and let us how we’re doing.
>
> /_IMPORTANT NOTICE_/
>
> /E-mails made or received in conjunction with the official business of
> the District are public records. All e-mails sent to and from this
> address are automatically archived. For more information regarding
> the State of Florida public records laws, please visit www.myflorida.com./
>
You might like to give psql a try, it runs on the command line.

I have used pgadmin3, but tend to find psql plus a text editor, a lot
easier to use.

I create an SQL file, like join000.sql and execute it from psql:

$ psql
psql (9.4.6)
Type "help" for help.

gavin=> \i join000.sql
DROP TABLE
DROP TABLE
DROP TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
INSERT 0 4
INSERT 0 4
INSERT 0 8
name
------
x
z
(2 rows)

name | sum
------+-----
q | 9.9
r | 10
(2 rows)

name
------
a b
p
(2 rows)

gavin=>

Cheers,
Gavin