PostgreSql Commands

 ---to enter from command line terminal

$sudo -u postgres psql

--asks for password



Link: https://www.microfocus.com/documentation/idol/IDOL_12_0/MediaServer/Guides/html/English/Content/Getting_Started/Configure/_TRN_Set_up_PostgreSQL.htm


https://gist.github.com/Kartones/dd3ff5ec5ea238d4c546


---Importing databasefile.sql to created database databasename

$psql -h localhost -U databaseuser -d databasename -f D:\Backup\databasefile.sql

reference:

https://sqlserverguides.com/postgresql-import-sql-file/

---Export database in windows

$pg_dump -U databaseuser databasename > testdbbackup.sql

reference:

https://www.prisma.io/dataguide/postgresql/inserting-and-modifying-data/importing-and-exporting-data-in-postgresql


Comments

Post a Comment

Popular posts from this blog

Create table in mysql database in phpmyadmin panel

DROP TABLE IF EXISTS `tablename`; CREATE TABLE IF NOT EXISTS `tablename` (   `id` int(11) NOT NULL AUTO_INCREMENT,   `AdminUserName` varchar(255) NOT NULL,   `AdminPassword` varchar(255) NOT NULL,   `AdminEmailId` varchar(255) NOT NULL,   `Is_Active` int(11) NOT NULL,   `CreationDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,   `UpdationDate` timestamp NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,   PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbladmin` -- INSERT INTO `tbladmin` (`id`, `AdminUserName`, `AdminPassword`, `AdminEmailId`, `Is_Active`, `CreationDate`, `UpdationDate`) VALUES (1, 'admin', 'password', 'admin@email.com', 1, '2019-02-10 17:51:00', '2019-02-15 08:52:44');
Read more