I often find myself wanting to run a query like this on multiple different databases: select n, pg_size_pretty(s) from ( select n, pg_total_relation_size(n) s from ( select format('%I.%I', table_schema, table_name) n from information_schema.tables ) ) order by s desc; How…
In postgres I can define custom option using set x.x = 12; I can also read it using following query SHOW x.x; But I couldn't find any command to list all such defined options. Is there anything I can use…
I have a price column in my .sql file that is currently a string of numbers (prices). I want to use python to modify the string of numbers and convert them into actual numbers (floats to be specific). This is…
On psql, I could call format() with 'Hello World' as shown below: postgres=# SELECT format('Hello World'); format ------------- Hello World (1 row) Now, dividing 'Hello World' into 'Hello ' and 'World' in one line with one space got the error…
I have a problem when I try to import a file to PostgreSQL. I'm using Postgresql 16.3 on Windows but whenever I try to import a new file (.sql) it doesn't work! My process on Postbird: File -> Import .sql…
There is a model: class Categories(models.Model): name = models.CharField(max_length=150, unique=True, verbose_name='Name') slug = models.SlugField(max_length=200, unique=True, blank=True, null=True, verbose_name='URL') class Products(models.Model): name = models.CharField(max_length=150, unique=True, verbose_name='Name') slug = models.SlugField(max_length=200, unique=True, blank=True, null=True, verbose_name='URL') category = models.ForeignKey(to=Categories, on_delete=models.PROTECT, verbose_name='Categoy') I don't understand…
On postgresql@12 I have a table with 300 millions rows and first query executes < 1s, but the second is 2 minutes. Why? I created all possible indexes. First query (< 1s): SELECT hash FROM _transfers WHERE (from_='abcd' or to_='abcd')…
I've problem with my database running on postgresql 16.2. My application is running fine, it can query data, but I'm not able to create a backup using pg_dump or inspect database via psql. Running pd_dump ends in following error: pg_dump:…
I was trying to reset the password. r9mzsy20=# ALTER USER 9mz_dba WITH PASSWORD '92837474'; ERROR: syntax error at or near "9" LINE 1: ALTER USER 9mz_dba WITH PASSWORD '92837474.. For user u_9mz_rw and u_9mz_ro I was able to reset the…
When I connect via psql with this command docker exec -it 4e18793cb23c psql -U postgres mytestdb, I can see my database and work with it. But when I connect with dbeaver to my postgres docker container, it doesn't show me…