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

Flutter Scratch Card

Image
 pubspec name :  extravote description :  A new Flutter project. publish_to :  'none'   version :  1.0.0+1 environment :    sdk :  ">=2.7.0 <3.0.0" dependencies :    flutter :      sdk :  flutter    http :  ^0.12.2    cached_network_image :  ^2.5.0    webview_flutter :  ^1.0.7         cupertino_icons :  ^1.0.2        workmanager :  ^0.2.3       flutter_local_notifications :  ^1.4.4+2    scratcher :  "^1.4.0"       confetti :  ^0.5.4+1 dev_dependencies :    flutter_test :      sdk :  flutter    integration_test :      sdk :  flutter flutter :    uses-material-design :  true    assets :     -  lib/as...
Read more