Postgres syntax randomness

C:\Program Files\PostgreSQL\9.3\bin

psql -U postgres -h localhost
psql (9.3.4)
WARNING: Console code page (437) differs from Windows code
         8-bit characters might not work correctly. See psq
         page "Notes for Windows users" for details.
Type "help" for help.

postgres=# create database anthonydb;
CREATE DATABASE

postgres=# \l
                                                 List of da
   Name    |  Owner   | Encoding |          Collate
           |   Access privileges
-----------+----------+----------+-------------------------
-----------+-----------------------
 anthonydb | postgres | UTF8     | English_United States.12
tates.1252 |
 postgres  | postgres | UTF8     | English_United States.12
tates.1252 |
 template0 | postgres | UTF8     | English_United States.12
tates.1252 | =c/postgres          +
           |          |          |
           | postgres=CTc/postgres
 template1 | postgres | UTF8     | English_United States.12
tates.1252 | =c/postgres          +
           |          |          |
           | postgres=CTc/postgres
(4 rows)

postgres=# create user admin with password 'admin';
postgres=# drop database mydb;
postgres=# \c anthonydb;

anthonydb=# create schema friends;

anthonydb=# create table friends.tableTest (fistname CHAR (15), lastname CHAR(20
));
CREATE TABLE

anthonydb=# \d friends.tableTest;
      Table "friends.tabletest"
  Column  |     Type      | Modifiers
----------+---------------+-----------
 fistname | character(15) |
 lastname | character(20) |



anthonydb=# insert into friends.tableTest values ('who cares', 'never mind');

  jdbc:postgresql://<host>:<port>/<dbname>?username=<username>&password=<password>
  
So
  export DATABASE_URL=jdbc:postgresql://localhost:5432/anthonydb?username=admin&password=admin  (linux)
  SET DATABASE_URL=postgres://admin:admin@localhost:5432/anthonydb  (windows}