Shulou(Shulou.com)06/01 Report--

Postgresql-9.4 version: pgAdmin III

Postgresql-11.5 version: pgAdmin4

Double-click pgsql\ pgAdmin4\ bin\ pgAdmin4.exe to launch pgAdmin4. After startup, a tray will be generated in the taskbar. Right-click the tray to copy the service interface through Copy Server URL, as follows:

Http://127.0.0.1:7634/?key=9641a3dc-cc73-4a90-a551-b92dec4df74d

Access it in a browser with the same function as pgAdmin III

Psql instruction

1) query all databases

Select * from pg_database

2) switch databases

\ C postgis_25_sample

3) execute sql script

\ I D:pas_device_info.sql

Note: put the script on disk C to execute an exception, indicating that the file does not exist. It is estimated that it is a permission problem.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.