Re: Getting started - pgadmin3 - Mailing list pgsql-novice

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@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.kubis@swfwmd.state.fl.us <mailto:steve.dicks@swfwmd.state.fl.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