why did I installed pgAdmin?
i wanted to see my database deployed on Render.
process
1. download pgAdmin
2. click ‘new server’ and make connection
- General > Name
- Connection >
- Host name/address: {internal_hostname}.{part_of_the_external_connection_string e.g. singapore-postgres.render.com}
- Port: Port(e.g.5432)
- Maintenance database: Database name
- Username: Username
error
pgAdmin connection failed: connection to server at "", port 5432 failed: SSL connection has been closed unexpectedly
- fixed an incorrectly written hostname → solved.
- open Query tool: right click the database > Query tool
- open Properties: right click the database > Properties…
- find tables: {database_name} > Schemas > public > Tables