****************** SQL test ******************
# Connected Databases List (C: current database is '*')
C | connect_name | user_name | target_name(db@host:port) | client_encoding
---+--------------+-----------+---------------------------+-----------------
| db1 | pgbash | pgbash_db1:5432 |
* | db2 | pgbash | pgbash_db2:5432 |
(2 rows)
# code # | # name # | # address #
----------+----------+-------------
1 | sakaida | osaka
2 | postgres | america
11 | | kobe
12 | | akasi
(4 rows)
1 , sakaida , osaka
2 , postgres , america
11 , -Z- , kobe
12 , -N- , akasi
TITLE
+------+----------+---------+
| code | name | address |
+------+----------+---------+
| 1 | sakaida | osaka |
| 2 | postgres | america |
| 11 | | kobe |
| 12 | | akasi |
+------+----------+---------+
(4 rows)
-- RECORD 0 --
code | 1
name | sakaida
address| osaka
-- RECORD 1 --
code | 2
name | postgres
address| america
-- RECORD 2 --
code | 11
name |
address| kobe
-- RECORD 3 --
code | 12
name |
address| akasi
(4 rows)
-- RECORD 0 --
code:1
name:sakaida
address:osaka
-- RECORD 1 --
code:2
name:postgres
address:america
-- RECORD 2 --
code:11
name:
address:kobe
-- RECORD 3 --
code:12
name:
address:akasi
(4 rows)
| # code # | # name # | # address # |
|---|
| 1 | sakaida | osaka |
| 2 | postgres | america |
| 11 | -0- | kobe |
| 12 | -NULL- | akasi |
(4 rows)
| code | name | address |
|---|
| 1 | sakaida | osaka |
| 2 | postgres | america |
| 11 | | kobe |
| 12 | | akasi |
(4 rows)
test case
| code | name | address |
|---|
| 1 | sakaida | osaka |
| 2 | postgres | america |
| 11 | | kobe |
| 12 | | akasi |
code | name | address
------+----------+---------
1001 | sakaida | osaka
1002 | postgres | america
1111 | mywife | kobe
111 | suzuki | kobe
222 | itirou | kobe
(5 rows)
code | name | address
------+----------+---------
1 | sakaida | osaka
2 | postgres | america
11 | | kobe
12 | | akasi
(4 rows)