Prepared statements versus stored procedures

Hi, First of all please forgive me. I'm not very experienced with databases. I was reading about prepared statements and how they allow the server to plan the query in advance so that if you execute that query multiple times it gets sped up as the database has already done the planning work. M

Re: Prepared statements versus stored procedures

On Sunday, 19 November 2023 at 18:09, Francisco Olarte wrote: > > > Hi Simon: > > On Sun, 19 Nov 2023 at 18:30, Simon Connah > simon.n.con...@protonmail.com wrote: > > > I was reading about prepared statements and how they allow the server to > > plan th

PostgreSQL DB in prod, test, debug

Hi, This project uses Python 3.12, Flask, psycopg3 and PostgreSQL 15. This is probably a stupid question so I apologies in advance. I'm building a website using PostgreSQL and since I've just been doing some dev work on it I've just manually played around with the database if I needed new tabl

Re: PostgreSQL DB in prod, test, debug

On Wednesday, 14 February 2024 at 10:25, Daniel Gustafsson wrote: > > > > On 14 Feb 2024, at 10:59, Simon Connah simon.n.con...@protonmail.com wrote: > > > This is probably a stupid question so I apologies in advance. > > > There is no such thing. >

Re: PostgreSQL DB in prod, test, debug

On Wednesday, 14 February 2024 at 10:38, Erik Wienhold wrote: > > > On 2024-02-14 10:59 +0100, Simon Connah wrote: > > > This project uses Python 3.12, Flask, psycopg3 and PostgreSQL 15. > > > > This is probably a stupid question so I apologies in adv

I have no idea why pg_dump isn't dumping all of my data

Hi, I'm running the following command to dump my database: /usr/bin/pg_dump --file=/home/simon/nanoscopic_db_127_0_0_1-2021_05_21_10_25_28-dump.sql --dbname=nanoscopic_db --clean --create --if-exists --username=nanoscopic_db_user --host=127.0.0.1 --port=5432 and yet when I run that all I get

Re: I have no idea why pg_dump isn't dumping all of my data

‐‐‐ Original Message ‐‐‐ On Friday, May 21st, 2021 at 10:55, Vijaykumar Jain wrote: > Can you try dumping using verbose flag. > -v > > Just want to confirm if the user has relevant permissions. > > On Fri, May 21, 2021, 3:04 PM Simon Connah > wrote: >

Re: I have no idea why pg_dump isn't dumping all of my data

n 2021-05-21 15:54:08 IST > > PostgreSQL database dump complete--***works > fine.I do not know that extension(nanoscopic) though. > > it is reading some tables in a public schema, but not even dumping the schema. > > yep, thats odd if

Re: I have no idea why pg_dump isn't dumping all of my data

‐‐‐ Original Message ‐‐‐ On Friday, May 21st, 2021 at 12:46, Ian Lawrence Barwick wrote: > 2021年5月21日(金) 20:42 Vijaykumar Jain vijaykumarjain.git...@gmail.com: > > > PostgreSQL: Documentation: 13: 37.17. Packaging Related Objects into an > > Extension > > > > so it works as expecte