Here is how to change column from NULL to NOT NULL in SQL Server, MySQL, PostgreSQL using ALTER TABLE statement.
PostgreSQL
How to Setup Remote Connection to PostgreSQL
You can easily enable remote access in PostgreSQL databases. Here is how to setup remote connection in PostgreSQL.
How to Compare Two Schemas in PostgreSQL
Sometimes you may need to compare two schemas in PostgreSQL. Here’s how to compare schemas in PostgreSQL.
Top Free Database Design Tools
Database design tools allow you to design database schema, and simplify database administration. Here are the top free database design tools for your business.
How to Enable SSL in PostgreSQL
How to Calculate Retention Rate in SQL?
Retention Rate is percent of users who return to use a product/service over a period of time. Here’s how to calculate retention rate in SQL. Calculate retention rate in MySQL, PostgreSQL.
How to Create Pivot Table in PostgreSQL
Pivot table & Crosstab makes in easy to analyze data. Here’s how to create pivot table in PostgreSQL.