PostgreSQL Tutorial

Installing Postgres :
Sudo apt-get update
Sudo install postgresql postgresql-contrib

 How lo login to user postgres :
sudo -i -u postgres

 Running Postgresql using :
psql

 Quit Postgresql using :
\q

 How to create new role :
createuser --interactive

 How to backup database using pg_dump utility :
pg_dump name_of_database > name_of_backup_file

 How to create Odoo User :
sudo adduser --system --home=/opt/odoo --group odoo
sudo su - odoo -s /bin/bash

Comments

Post a Comment

Popular posts from this blog

How to learn data structure effectively

Step 1 : Learn the theory and fundamentals Understand top fundamental topics covered in data structures such as: Algorithms, Arrays, Collections, Complexity Analysis, Graphs, Hashtables, Heaps, Linked Lists, Queues, Recursion, Search, Sort, Stacks, Trees You can checkout these websites to help cover fundamentals: www.geeks4geeks.com  - explains all the high level fundamentals www.beehyve.io/data-structures  — student crowdsourced resources and community for any topic in CS including Data Structures Time complexity resources [BeeHyve]Time Complexity Cheat Sheet https://visualgo.net/en  - has visualizations of a lot of helpful algorithms Here are more schools that have DS classes which you may find helpful: CS 226 Algorithms and Data Structures Brown CS 16 Introduction to Algorithms and Data Structures Stanford CS 166 Data Structures CMU CSE 15-211 Fundamental Data Structures and Algorithms University of Washington at St. Louis CSE 241 Algorithms a...
Read more

How to Learn to Code, Fast

Image
This article is focused on what to do and what not to do when learning to code. It’ll also give you tips on how to learn in the most efficient way possible. These tips are based on Natasha Postolovski’s experiences as a self-taught developer, now working as a software developer at ThoughtWorks in Australia. You can follow her on Twitter at  @npostolovski . It seems that more people than ever before have decided to learn to code. The abundance of high-quality educational materials, tutorials, and mentors on the internet means that self-starters from many different backgrounds can teach themselves programming, whether their goal is to build an app, create a website, solve a particular problem with technology, or become a software developer. Having so many learning resources available is a good thing, but it also presents a problem. When you want to learn to code, where should you start? What do you learn, and what don’t you learn? What’s the best way to ...
Read more

Download Binary file in Odoo 10

To download any binary file in Odoo10 following is the link: http://127.0.0.1:8069/web/content?model=<module_name>&field=<field_name>&filename_field=<field_filename>&id=<object_id> module_name    - the name of the model with the Binary field field_name         - the name of the Binary field object_id            - id of the record containing particular file. field_filename    - name of a Char field containing file's name (optional). So if you want to call a function on button click and download the file, code is as follow: file_url = "http://127.0.0.1:8069/web/content?model=<module_name>&field=<field_name>&filename_field=<field_filename>&id=<object_id>" return {     'type': 'ir.actions.act_url',     'url': file_url,     'target': 'new' } In Reports or web page, you can use...
Read more