I need to programmatically insert tens of millions of records into a Postgres database. Presently I am executing thousands of insert statements in ...
-
May 16, 2022
- 0 Comments
I have created a table in postgreSQL. I want to look at the SQL statement used to create the table but cannot figure ...
-
May 14, 2022
- 0 Comments
My docker compose file has three containers, web, nginx, and postgres. Postgres looks like this: postgres: container_name: postgres restart: always image: postgres:latest volumes: ...
-
May 14, 2022
- 0 Comments
How do I list all extensions that are already installed in a database or schema from psql? See also Finding a list of ...
-
May 12, 2022
- 0 Comments
How can I call psql so that it doesn’t prompt for a password? This is what I have: psql -Umyuser < myscript.sql However, ...
-
May 12, 2022
- 0 Comments
A very frequently asked question here is how to do an upsert, which is what MySQL calls INSERT ... ON DUPLICATE UPDATE and ...
-
May 12, 2022
- 0 Comments
I am trying to copy an entire table from one database to another in Postgres. Any suggestions? 22 Answers 22
I’m using psql’s \dt to list all tables in a database and I need to save the results. What is the syntax to ...
-
May 11, 2022
- 0 Comments
I have Postgresql on a server in a docker container. How can I connect to it from the outside, that is, from my ...
-
May 8, 2022
- 0 Comments