postgreSQL

postgreSQL Library Doc in Bangla

• PostgreSQL USE on Linux Terminal
  • Connection
    • postgres এ Login
    • alter postgres user password
    • যদি specific user as (postgres) এবং specific DataBase as (db_demo) ব্যবহার করে connect করতে চাই তাহলে
    • যদি এমন কোন DataBase এ connect করতে হয় যা আলাদা port থেকে Host করা ,তা হলে -h টাগ টি add করতে হবে
    • কোন কারণে যদি SSL key ব্যবহার করে DataBase এ connect করতে হয় ,তা হলে “dbname এবং sslmode” টাগ টি add করতে হবে
  • Create user
    • create a user without any rools
    • giving user a password
    • create user from postgres CLI with password
    • Granting privileges on a database
    • view all users
    • give user specific roles
    • you may, for some reason want to do it purely via psql, then these are the three magic commands
  • Drop or Delete user
    • reassign owned by
    • Drop User by
  • Create DataBase
    • নতুন DataBase as newbd তৈরি করতে : (generally give smaller letter)
    • List available Data-Base (press q to quite)
    • create database with specific user
    • connected to existing DataBase named newdb by
    • Drop or Delete a database that has no active connection
  • Create Schema
    • create a schema named newschema inside newdb database by
    • List available schema
  • Create Table
    • create a table t1 with columns (id,password) inside schema newschema by
    • List available tables
  • Describe a table
    • To describe a table such as a column, type, modifiers of columns, etc., you use the following command
    • now see all created table by
    • List users and their roles (To list all users and their assign roles, you use \du command
    • Command history (To display command history, you use the \s command.)
    • Execute psql commands from a file (In case you want to execute psql commands from a file, you use \i command as follows:)
    • Edit command in your own editor
    • Quit psql
• pgcron doc
• add to postgresql.conf
• required to load pg_cron background worker on start-up
• add to postgresql.conf
• optionally, specify the database in which the pg_cron background worker should run (defaults to postgres)
• hostname:port:database:username:password
• Schedule jobs via background workers instead of localhost connections
• Increase the number of available background workers from the default of 8