santattech

import 'dart:convert';
import 'dart:core';

void main() {
  var json = {
    'data': [
      {'id': 1, 'attributes': {'name': "Ram"}}, {'id': 2, 'attributes': {'name': "Shyam"}}
    ]
  };

santattech

Postgres collation version issue

What is PG collation?

A collation is an SQL schema object that maps an SQL name to operating system locales. A collation specifies the bit patterns that represent each character in a dataset and determine the rules used to sort and compare data. Collation attributes can have an impact on query results because they govern how sorting and comparison operations function.

How do I get collation in PostgreSQL?

To find the collation of the database, you need to query pg_database : select datname, datcollate from pg_database;

What was the error?

Recently I have updated my OS version from Ubunutu 20 to Ubuntu 22. After that whenever I tried to create a database in my Postgresql, it throws error. Below is the error shown:

santattech

Few important links

Install Ubuntu on WSL2 on Windows 10

https://ubuntu.com/tutorials/install-ubuntu-on-wsl2-on-windows-10#2-install-wsl

username: santattech
password: 123456

santattech

Error

running the docker command with sudo giving error from docker volume, like permission denied uninstall docker install docker follow post install steps https://docs.docker.com/engine/install/ubuntu/#uninstall-old-versions https://docs.docker.com/engine/install/linux-postinstall/

steps so far

1. netgear + vpn

santattech

Basic Interview Questions

C

• What is data type in C?
• What is sizeOf function in C?
• What is syntax of ternary operator in C?
• Difference between = and ==
• What is pointer?
• What is NULL pointer?