It does matter what the column order is in PostgreSQL.
- 13 November 2022
- Database Performance ManagementSoftware Engineering
Recently, I came across some really broad tables with hundreds of columns in a database that was not particularly well organized. Our PostgreSQL suppo…
Oracle NVL2 function
- 12 November 2022
- Database Performance ManagementSoftware Engineering
Oracle/PLSQL NVL2 function extends the functionality of the NVL function. It replaces the value when a Null value is encountered and also when a non-N…
Oracle ASCII function
- 5 November 2022
- Software Engineering
The Oracle/PLSQL ASCII function returns the numeric representation of the leftmost character of the string….
Oracle DUMP function
- 2 November 2022
- Database Performance ManagementSoftware Engineering
The Oracle/PLSQL DUMP function returns a value of varchar2, which includes data type code, length in bytes, and the internal representation of the exp…
TRANSFER PGAGENT SCHEDULED JOBS TO PG TIMETABLE
- 30 October 2022
- Database Performance ManagementDeep learningSoftware Engineering
Why go from pgAgent to pgTimetable?
Actually, there are numerous justifications for why someone would wish to export pgAgent jobs to a pg timetable. T…
The views expressed on this blog are those of the author and do not necessarily reflect the opinions of Enteros Inc. This blog may contain links to the content of third-party sites. By providing such links, Enteros Inc. does not adopt, guarantee, approve, or endorse the information, views, or products available on such sites.
Are you interested in writing for Enteros’ Blog? Please send us a pitch!