want to know better way where can see list of depecrated functions in Postgres ? submitted by /u/aviboy2006 [visit reddit] [comments ..read more

I had OpenBSD server with PostgreSQL and PHP that was working just fine, but I needed to re-install it to fix some partition size problem. After I reinstalled OpenBSD 7.5, at some point while I was struggling (problems restoring the db dump) to setup PostgreSQL 16.2 I came to a point (after I created my scheme) that a \d from the client on my home machine would show nothing, but a \d from the client running on the server would show all my tables and views. After a few wipe/retry later I got it working (\d from home would work), but then I found that from PHP it would still not find any tables ..read more

A new release introduces improvements and bug fixes have been published https://github.com/GreenmaskIO/greenmask Changes Fixed panic caused by Large Object dumper If you are not familiar yet with Greenmask - it is a Database anonymization tool that brings wide anonymization functionalities and techniques. Check out the Playground page to get started submitted by /u/anyweny [visit reddit] [comments ..read more

Has anyone else had this issue it connect successfully to the database and everything but I can not see the names in the tree? See attached picture: https://preview.redd.it/xaw7q3bjxkzc1.png?width=382&format=png&auto=webp&s=ac44518b34248ce290ba206a864b023b9ed0bf84 submitted by /u/Mattixio [visit reddit] [comments ..read more

Hi Everyone, I am 25M, doing market research for understanding the challenges and experiences while learning SQL or any other databases or programming language. It will hardly take 2-3 Minutes. I am not selling or promoting anything. The reason of my research is, I'm working on an AI Startup Idea to make something for making learning experience more effective. You have to just fill the form mentioned below: SQL Insight - Share Your Experience Kindly share your experience and challenges you faced while learning. Thanks in advance! submitted by /u/SecretTadpole7120 [visit reddit] [comments ..read more

Hello All, We want to make sure to keep minimal privileges for the users based on their roles and responsibility. We have one user group who will be working on analyzing/debugging into performance issues in the databases. Basically this group will be operating on extensions like apg_plan_management, pg_hint_plan, auto_explain, plprofiler, pg_repack. So these extensions will already be installed for the group, but they will just need to use those appropriately. For example pg_hint_plan will not need any write privilege because the user just has to put the hint in the query and run it to see an ..read more

submitted by /u/prlaur782 [visit reddit] [comments ..read more

Based on feedback and finding out there is a version 3. I've made aws layers, they're easy to make but for the especially lazy: here there are. All premade: psycopg version Python version File name 2 3.10 psycopg2_3.10 2 3.11 psycopg2_3.11 2 3.12 psycopg2_3.12 2 3.8 psycopg2_3.8 2 3.9 psycopg2_3.9 3 3.10 psycopg3_3.10 3 3.11 psycopg3_3.11 3 3.12 psycopg3_3.12 3 3.8 psycopg3_3.8 3 3.9 psycopg3_3.9 They can be found here submitted by /u/2yan [visit reddit] [comments ..read more

Hi all, I have recently installed the new version of SQL on one of my colleagues PCs however every time we try and import a database we get the following error. Can you please help? I have also tried to install the Microsoft access database 2016 redistributable but this made no difference, please can you help? The Microsoft ACE.OLEDB. 12.0 provider is not registered on the local machine. (System Data) The general advice online is to install older versions of Microsoft access databases hoeder every time I click a link takes me to Microsoft and says link is no longer available, cannot find the ..read more

submitted by /u/pg_forever [visit reddit] [comments ..read more