Last active
December 16, 2018 16:16
-
-
Save chandankumar4/49e411b66b7c7f4ec6bdc62af8347829 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# Install PostSql (Ubuntu) | |
sudo apt-get install postgresql postgresql-contrib | |
------------------------------------------------------------------------------------------------------------------ | |
# Delete PostSql (Ubuntu) | |
dpkg -l | grep postgres | |
sudo apt-get remove --purge postgresql postgresql-9.5 postgresql-client-9.5 postgresql-client-common postgresql-common postgresql-contrib postgresql-contrib-9.5 | |
rm -r /etc/postgresql/ | |
rm -r /etc/postgresql-common/ | |
rm -r /var/lib/postgresql/ | |
userdel -r postgres | |
groupdel postgres | |
------------------------------------------------------------------------------------------------------------------ | |
# Postgress related command | |
sudo -u postgres psql # Login to database | |
ALTER USER postgres PASSWORD 'myPassword'; # change password | |
\list # list all postgres database name | |
\dt # list all table | |
\d gke # Display table properties | |
SELECT * FROM weather; # select data from table | |
CREATE TABLE account(id serial PRIMARY KEY,username VARCHAR (50) UNIQUE NOT NULL); # create table | |
INSERT INTO tablename (field1, field2) values ('value1', 2); # insert data in table | |
CREATE TABLE test(id INT PRIMARY KEY, sha VARCHAR, ref VARCHAR,status VARCHAR, web_url VARCHAR); # create table | |
UPDATE test SET STATUS = 'passed' WHERE id = 4956; # update row inside table | |
ALTER TABLE test3 ADD COLUMN jobs2 JSON[]; # Add column to table | |
SELECT id FROM test ORDER BY id DESC LIMIT 1 OFFSET 3; # Select 4th row id of table | |
------------------------------------------------------------------------------------------------------------------ | |
# Useful links | |
https://www.calhoun.io/using-postgresql-with-go/ | |
https://stackoverflow.com/questions/1109061/insert-on-duplicate-update-in-postgresql |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment