Download

About

Very simple postgres sql client
Простой postgres клиент для выполнения SQL команд

Please don’t hesitate to contact me if you have any questions. Vlad Alexeenkov

Limits

How to use

  1. Download

  2. Unarchive

  3. Run:

    • Linux: ./bin/vpgsql

    • Windows: bin/vpgsql.exe

1.1 Execute SQL command (Ctrl + E)

Select command and press Ctrl + E

1 exec

1.2 Execute function returning refcursor (Ctrl + E)

Command call: select func_name(parametrs) Select command and press Ctrl + E

2 refcursor

1.3 Template for SELECT (Ctrl + Shift + S)

Select table name and press Ctrl + Shift + S.

3 select templ

1.4 Template for INSERT (Ctrl + Shift + I)

Select table name and press Ctrl + Shift + I.

4 insert templ

1.5 Template for UPDATE (Ctrl + Shift + U)

Select table name and press Ctrl + Shift + U.

5 update templ

1.6 Temporary table save (Ctrl + Shift + C …​ Ctrl + Shift + N)

Step 1. Select table name and press Ctrl + Shift + C. Copy template and execute it

6 create templ

Step 2. Process table Step 3. Select table name and press Ctrl + Shift + N. Copy template and execute it

7 insert from templ

Step 4. Delete tmp_ table

1.7 Query plan (Ctrl + Shift + P)

Select query and press Ctrl + Shift + P.

8 show plan

1.8 Create RETURNS for function returning TABLE (Ctrl + Shift + R)

9 returns tab

1.9 Fast SELECT * FROM …​ from table (Ctrl + Shift + E, Ctrl + Shift + L)

Select table name and press Ctrl + Shift + E
Ctrl + Shift + L - adds limit 100

10 select

1.10 Fast SELECT count(*) FROM …​ from table (Ctrl + Shift + O)

Select table name and press Ctrl + Shift + O

11 count

1.11 Find table (Ctrl + Shift + T)

Select text and press Ctrl + Shift + T

12 like table

1.12 Find function (Ctrl + Shift + F)

Select text and press Ctrl + Shift + F

14 like func

1.13 View table size of schema (Ctrl + Shift + A)

Select schema name and press Ctrl + Shift + A

15 size

1.14 View table references (Ctrl + Shift + J, Ctrl + Shift + K)

Ctrl + Shift + J incoming references Ctrl + Shift + K outcoming references

16 reference

1.15 Fast compare two DB

  1. Step 1 get scrint for dblink creation.

  2. Step 2 - view tables that exists in DB and absent in remote

  3. Step 3 - view tables that absent in DB and exists in remote

  4. Step 4 - view table fields that exists in DB and absent in remote

  5. Step 5 - view table fields that absent in DB and exists in remote

  6. Step 6 - view indexes that exists in DB and absent in remote

  7. Step 7 - view indexes that absent in DB and exists in remote

  8. Step 8 - view references that exists in DB and absent in remote

  9. Step 9 - view references that absent in DB and exists in remote

17 db compare