Postgres Emport And Export Database
Remeber logs:- Play with Postgres Console Login to Postgress Console:- $ 1. psql -U pg_user_name 2. psql -h localhost(host) -U pg_user_name See Database:- $ \l Create New Database:- $ create database Databasename; To switch databases: $\connect databasename; To list all table $ \d To Insert records: INSERT INTO TABLE_NAME ( column1 , column2 , column3 ,... columnN ) VALUES ( value1 , value2 , value3 ,... valueN ); $insert into articles(title) values(33); T0 list record: $ SELECT * FROM articles; Play with Mysql Console: Install mysql: sudo apt-get install mysql-server mysql-client libmysqlclient-dev Login to Mysql Console:- $ mysql -u root -p See Database:- $ show databases; Create New Database:- $ create database Databasename; To switch databases: $ use mydb; or connect dbnae; To list all table $ show tables; To Insert records: INSERT INTO TABLE_NAME ( column1 , column2 , column3 ,... columnN ) VALUES ( value1 , value2 , value3 ,... valueN ); $insert into articles(titl...