Category "pgadmin-4"

Pgadmin server is empty

I have recently installed PostgresSQL and my servers are just empty. I am sure I should have servers under servers and a database to play with but I have nothin

unable to close output pane in pgadmin4

How to close the pgamin output window.. I dragged/popped out the output window of pgadmin 4 .. and now I can't close it/merge it back on the top tile. Restartin

Copy file from remote server to local machine in Postgres

I cannot figure out how I can copy a remote server file as a CSV file on my local machine (windows). I have tried \copy mytable TO 'C:/pg/mytable.csv' CSV DELIM

Postgres and Docker Compose; password authentication fails and role 'postgres' does not exist. Cannot connect from pgAdmin4

I have a docker-compose that brings up the psql database as below, currently I'm trying to connect to it with pgAdmin4 (not in a docker container) and be able t

How to export table data from PostgreSQL (pgAdmin) to CSV file?

I am using pgAdmin version 4.3 and i want to export one table data to CSV file. I used this query COPY (select * from product_template) TO 'D:\Product_template

How to export table data from PostgreSQL (pgAdmin) to CSV file?

I am using pgAdmin version 4.3 and i want to export one table data to CSV file. I used this query COPY (select * from product_template) TO 'D:\Product_template

How to permanently save the path of the identity file in pgAdmin4

Context I'm using this pgAdmin4 docker image: https://hub.docker.com/r/dpage/pgadmin4/ in its latest state (version 6.9 at the time of writing). And I am curren