Content-type: text/html ****************** SQL test ******************
| C | connect_name | user_name | target_name(db@host:port) | client_encoding |
|---|---|---|---|---|
| db1 | pgbash | pgbash_db1:5432 | ||
| * | db2 | pgbash | pgbash_db2:5432 |
| code | name | address |
|---|---|---|
| 1 | sakaida | osaka |
| 2 | postgres | america |
| 11 | mywife | kobe |
| code | 1 |
| name | sakaida |
| address | osaka |
| code | 2 |
| name | postgres |
| address | america |
| code | 11 |
| name | mywife |
| address | kobe |
| code | name | address |
|---|---|---|
| 1 | sakaida | osaka |
| 2 | postgres | america |
| 11 | mywife | kobe |
| code | name | address |
|---|---|---|
| 1 | sakaida | osaka |
| 2 | postgres | america |
| 11 | mywife | kobe |
| code | name | address |
|---|---|---|
| code | name | address |
|---|---|---|
| 1 | ||
| 2 | ||
| 11 |
| code | name | address |
|---|---|---|
| 1 | ||
| 2 | ||
| 11 |
| code | 1 |
| name | |
| address |
| code | 2 |
| name | |
| address |
| code | 11 |
| name | |
| address |
1 , sakaida , osaka
2 , postgres , america
11 , mywife , kobe
code | name | address
------+----------+---------
1 | sakaida | osaka
2 | postgres | america
11 | mywife | kobe
(3 rows)
TITLE
+------+----------+---------+
| code | name | address |
+------+----------+---------+
| 1 | sakaida | osaka |
| 2 | postgres | america |
| 11 | mywife | kobe |
+------+----------+---------+
(3 rows)
|
| code | name | address |
|---|---|---|
| 1001 | sakaida | osaka |
| 1002 | postgres | america |
| 1111 | mywife | kobe |
| code | name | address |
|---|---|---|
| 1 | sakaida | osaka |
| 2 | postgres | america |
| 11 | mywife | kobe |