Use of PostgreSQL login tools pgAdmin and psql
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.
