How to Show Current Database in PostgreSQL

This article is also written for describing about how to show current database accessed or being operated in PostgreSQL Database Server and it is related with the management function of PostgreSQL Database Server.

In order to show the current database accessed or being operated, it must be done by executing a specific command which is typed in the PostgreSQL Command Console.

To be able to log in to the PostgreSQL Command Console, there are several things which is needed to be confirmed.

1. Make sure that the PostgreSQL Database Server is properly installed.

2. Make sure that the service of PostreSQL Databse Server is running and active. Read the article titled ‘Check PostgreSQL Service Status’ in this link.

3. Make sure that PostgreSQL Command Console can be accessed and to be logged in for further operation which in the context of this article is for showing the current database accessed in PostgreSQL Command Console. In order to do that, the article titled ‘Check PostgreSQL Service Status’ in this link can be used as further reference. Below is the process of logging in to PostgreSQL Database Server :

Continue reading “How to Show Current Database in PostgreSQL”

How to Show Current User in PostgreSQL

This is one of the article relates on the management of PostgreSQL Database Server. The function which is the focus of the database management specifically in PostgreSQL Database Server is about how to show current user in PostgreSQL Database Server. The function for showing current user in PostgreSQL Database Server only works after logging in into PostgreSQL Command Console.

The main function in the management of PostgreSQL Database Server to show current user in the PostgreSQL Command Console after logging in is just to make sure that the SQL command executed further later on will be executed by the correct user.

Before logging in to the PostgreSQL Command Console, make sure that PostgreSQL Database Server is installed and the service is currently running. In order to check the service, just read the article titled ‘Check PostgreSQL Service Status’ in this link.

After checking the service and the service itself is currently running, just logged in to the PostgreSQL Database Server. In order to logged in to PostgreSQL Command Console, just read the article titled ‘PostgreSQL Database Access from Command Line in Linux’ in this link.

After logging in to PostgreSQL Comamnd Console, the SQL command executed in PostgreSQL Command Console itself where in this context is to show current user in PostgreSQL Database Server is shown below :

Continue reading “How to Show Current User in PostgreSQL”

All PostgreSQL Articles

This page is a page which contain all articles about PostgreSQL Database and all things related on it :

PostgreSQL Management Function

  1. How to Check PostgreSQL Database Server’s service status.

  2. How to Check PostgreSQL Database Server’s version via Command Console.

  3. How to Access PostgreSQL Database Server via Command Line.

PostgreSQL SQL Query Command

  1. How to Show Current Database in PostgreSQL Database Server via PostgreSQL Command Console.

  2. How to Show Current User in PostgreSQL Database Server via PostgreSQL Command Console.

  3. How to Show Available User in PostgreSQL Database Server via PostgreSQL Command Console.

  4. How to Show Available User with Role in PostgreSQL Database Server via PostgreSQL Command Console.

 

How to Check PostgreSQL Version via Command Console

This is yet another article relates on PostgreSQL which is focusing to show how to check the PostgreSQL version via command console. Off course, the main point is the PostgreSQL Database Server must be installed and has already started. To check whether the service has already been installed or not just do the following step :

Check the service of PostgreSQL Database Server. To grasp on how to do it, just read the article titled ‘Check PostgreSQL Service Status’ in this link.

After everything has already been checked, mainly the PostgreSQL Database Server installation, the service itself also has already running properly, the process for checking the version can be performed.

PostgreSQL Database Server’s version :

Continue reading “How to Check PostgreSQL Version via Command Console”

All Laravel Articles

This page is a page which contain all articles about Laravel Framework and all things related on it :

Tips and Trick

PHP Artisan

  1. How to Create a Laravel Project using PHP Composer Command .
  2. How to Create a Model in Laravel using PHP Artisan Command .
  3. How to Create Model with Migration Script in Laravel .
  4. How to Create a Controller in Laravel using PHP Artisan Command .
  5. How to Create a Middleware in Laravel using PHP Artisan Command .
  6. How to Print Available Route in Laravel using PHP Artisan Command .
  7. How to Generate Table in Laravel using PHP Artisan Command .

PHP Artisan Migration Script

  1. How to Create a Migration Script in Laravel using PHP Artisan Command .
  2. How to Reexecute Migration Script in Laravel Using PHP Artisan Command .
  3. How to Drop Table Created and Recreate the Table with Migration Script in Laravel using PHP Artisan Command .

PHP Artisan Tinker

  1. How to Use PHP Artisan Tinker to Insert Data .
  2. How to solve Laravel Error Messsage rmdir(/tmp/php-xdg-runtime-dir-fallback-root): Directory not empty using PHP Artisan Tinker in Laravel .
  3. How to Insert a New Record Using PHP Artisan Tinker in Laravel .
  4. How to Solve Laravel Error Message : Call to undefined method stdClass::save() when using PHP Artisan Tinker in Laravel .
  5. How to Solve Laravel Error Message : SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘column_name’ in ‘field list’ using PHP Artisan Tinker in Laravel .

 

PHP Artisan Key

  1. How to generate key in Laravel .

General

  1. How to Create Laravel Project with Authentication .
  2. How to Install Laravel to a certain directory .
  3. How to Install a Specific Version of Laravel using Composer .
  4. How to Define onsubmit on Blade Form Tag Laravel .
  5. How to Change the name of the Laravel application .
  6. How to Check Array in Blade View Template .
  7. How to Disable Proxy in Installing Package Using npm .
  8. How to Prevent Form Submit using JQuery in Laravel .
  9. How to Add an Option HTML Element functioned as An Information Label to Select in Laravel .
  10. How to Get Full URL in Blade View Template File in Laravel .
  11. How to Display Username whom is currently Login in Laravel .
  12. How to Reset Password of a User in Laravel .
  13. How to Create a Login Page in Laravel .
  14. How to Add JQuery in Blade View Template File in Laravel .
  15. How to Use Return View vs Return Redirect in Laravel .
  16. How to Configure MySQL Database Connection in Laravel .
  17. How to Generate Key in Laravel .
  18. How to Use Bootstrap in Laravel .
  19. How to Change Primary Key of a Model in Laravel .
  20. How to Print Variable for Debugging using dd command in Laravel .
  21. How to Check Laravel Version using Several Method in Laravel .
  22. How to Create Apache Configuration for Laravel Web-based Application .
  23. How to Change URL of Laravel Web-based Application .
  24. How to Remove Database Migration Script File in Laravel .
  25. How to Check Database Migration Status in Laravel .
  26. How to Pass Array from Controller to View in Laravel using Compact .
  27. How to install Baum for Laravel .

Error

  1. How to solve Laravel Error Message MethodNotAllowedHttp on Submit to Update Form.
  2. How to solve Laravel Error Message 422 Unprocessable Entity .
  3. How to solve Laravel Error Message Content-Mismatch on Creating Laravel Project .
  4. How to solve Laravel Error Message composer.json does not contain valid json .
  5. How to solve Laravel Error Message Uncaught ReflectionException: Class 0 does not exist .
  6. How to Solve Laravel Error Message mkdir Permission Denied on Creating a Laravel Project .
  7. How to Solve Laravel Error Message Bootstrap Cache Permissions .
  8. How to Solve Laravel Error Message Undefined Variable in Blade View Template File .
  9. How to Solve Laravel error Message NotFoundHttpException .
  10. How to Solve Laravel Error Message Cannot use object of type stdClass as array .
  11. How to Solve Laravel Error Message Call to undefined method stdClass::toArray() .
  12. How to Solve Laravel Error Message Class Name does not exist .
  13. How to Solve Laravel Error Message SQLSTATE[42S22]: Column not found: 1054 Unknown column .
  14. How to Solve Laravel Error Message Route not Defined .
  15. How to Solve Laravel Error Undefined index : Column .
  16. How to Solve Laravel Error Message : The Response content must be a string or object implementing __toString(), “boolean” given .
  17. How to Solve Laravel Error Message : Access level to App\Test::$incrementing must be public (as in class Illuminate\Database\Eloquent\Model) .
  18. How to Solve Laravel Error Message : Creating default object from empty value .
  19. How to Solve Laravel Error Message : Access level to $timestamps must be public (as in class Illuminate\Database\Eloquent\Model) .
  20. How to Solve Laravel Error Message : access denied for user ‘homestead’@’localhost’ (using password yes) .
  21. How to Solve Laravel Error Message : Class ‘App\Http\Controllers\Input’ not found .
  22. How to Solve Laravel Error Message : The only supported ciphers are AES-128-CBC and AES-256-CBC with the correct key lengths .
  23. How to Solve Laravel Error Message : TokenMismatchException .
  24. How to Solve Laravel Error Message : Your requirements could not be resolved to an installable set of packages .
  25. How to Solve Laravel Error Message : Composer Message Package illuminate/html is abandoned, you should avoid using it. Use laravelcollective/html instead .
  26. How to Solve Laravel Error : Message Call to undefined method Collective\Html\Formfacade::open() .
  27. How to Solve Laravel Error Message : View index not found .
  28. How to Solve Laravel Error Message : Controller::index() does not exist .
  29. How to Solve Laravel error: MethodNotAllowedHttpException in RouteCollection.php display .
  30. How to Solve Laravel Error Message : Views Folder Permission Denied .
  31. How to Solve Laravel Error Message : View index not found .
  32. How to Solve Laravel Error Message : Base table or view not found .
  33. How to Solve Laravel Error Message : Model does no exist .
  34. How to Solve Laravel Error Message : Request Class does not exist .
  35. How to Solve Laravel Error Message : Controller does not exist .
  36. How to Solve Laravel Error Message : Character double colon does not exist .
  37. How to Solve Laravel Error Message : File view welcome does not exist .
  38. How to Solve Laravel Error Message : Failed opening required ‘vendor/autoload.php’ .
  39. How to Solve Error Message “laravel.log” could not be opened: failed to open stream: Permission denied .
  40. How to Solve Laravel Error Message Method method name does not exist.

Laravel Error Message on Creating or Inserting a New Record into a Table

  1. Laravel Error Message : 1406 Data too long for column .

Laravel Error Message on Migration

  1. Laravel Error Message : Cannot declare class Class Name, because the name is already in use .
  2. How to execute only specific migration script file in Laravel .

Validation

  1. How to use Laravel Validation Feature to check Empty Field of an Input Type HTML Element .
  2. How to use AJAX for Validation in Laravel .

Message

  1. How to Show Edit Success Message in Laravel .

Database Query

  1. How to update a field in a table of a database using DB Class in Laravel .
  2. How to update multiple field in a table of a database using DB Class in Laravel .
  3. How to use Left Join Operation using DB Class in Laravel .
  4. How to use Multiple Where Condition using DB Class in Laravel .
  5. How to check a field is not null using DB Class in Laravel .
  6. How to print SQL Query using toSql function in Laravel .
  7. How to Execute Query Update Using Model Class where the data retrieved from Blade View Template Form using Input Class in Laravel .
  8. How to Execute Query Update Using DB Class where the data retrieved from Blade View Template Form using Input Class in Laravel .

All Git Articles

This page is a page which contain all articles about Git Versioning Control and all things related on it :

Tips and Trick

  1. How to Initialize a Local Git Repository .
  2. How to clone or duplicate a Git repository .

Error

  1. How to solve “change not stated for commit” in git commit operation.
  2. How to solve Git push Error Message [remote rejected] master -> master .
  3. How to solve Error Message fatal: Dirty repository: Having uncommitted changes. Exiting… upon executing git ftp push.

 

All Linux Articles

This page is a page which contain all articles :

Command

  1. How to Check hard disk Size in Linux .
  2. How to Check Domain Name Server in Linux .
  3. How to Check Socket Size in Linux .
  4. How to Copy or Duplicate Image remotely via SSH in Linux .
  5. How to Use wget to Download Recursively Linux .
  6. How to Change hostname in Linux .
  7. How to Sort File by Size in Linux .
  8. How to Use Screen in Linux .
  9. How to Use ss to Show List of Listening Service in Linux .
  10. How to Use htop in Linux .
  11. How to Use netstat to Show List of Listening Service in Linux .
  12. How to Use wget to Download with Resume Option in Linux .
  13. How to Use pwd to Show Current Working Directory in Linux .
  14. How to Use ls to Show Content of a Directory in Linux .
  15. How to Create empty file in Linux .
  16. How to Use du to Show File size in Linux  .
  17. How to Use du to Calculate Directory size in Linux .
  18. How to Use su to Switch User in Linux .
  19. How to Use whoami to Check Current Logging User in Linux .
  20. How to Use md5sum to Check File Image integrity .
  21. How to Use Check Physical Memory Size in Linux .
  22. How to Check Operating System Name and Version in Linux .
  23. How to Change Directory Permissions in Linux Recursively .

Tips and Trick

  1. How to Boot Linux from GRUB Command Line .
  2. How to SSH Automatically without Password using Public Key .
  3. How to Troubleshoot Network Interface Error : eth does not seem to be present delaying initialization .
  4. How to get Wifi Connection Saved Password in Linux .
  5. How to Backup Logical Volume via Samba Shared Folder in Linux .
  6. How to Mount Samba Shared Folder and Copy the Files in Linux .
  7. How to Search a text in a file in Linux .
  8. How to Disable squashfs Filesystem in Linux .
  9. How to Disable udf Filesystem in Linux .
  10. How to Disable cramfs Filesystem in Linux .
  11. How to Convert mp4 to mp3 in Linux via Command Line .
  12. How to Set Default umask User in Linux .
  13. How to Solve Failed Package Installation because of gpg key .
  14. How to Remove User Home Directory after Deleting User .
  15. How to Configure wget to Download via Proxy .
  16. How to Add Executable Permission in Linux .
  17. How to Remove GUI in Linux CentOS .
  18. How to Change Run Level of a Service in Linux CentOS .
  19. How to Solve NetworkManager does not started automatically .
  20. How to Extract Compressed File tar.gz .
  21. How to Create Bootable Operating System Installer .
  22. How to Check Operating System Version .
  23. How to Check Ubuntu Version .

Software Installation

  1. How to Install Internet Explorer 7 on Linux using PlayOnLinux .
  2. How to Install Internet Explorer 8 on Linux using PlayOnLinux .
  3. How to Install Inkscape in Linux .
  4. How to Install Gitlab in Linux via Command Line .
  5. How to Install Adobe Photoshop in Linux using PlayOnLinux .
  6. How to Install Adminer in Linux .
  7. How to Install PlayOnLinux in Linux .
  8. How to Install LAMPP in Linux .
  9. How to Install Docker in Linux .
  10. How to Install KVM and Libvirt in Linux .
  11. How to Install tree command in Linux via Command Line .

Sudo Command

  1. How to Solve Error for failing to execute sudo Command .
  2. How to Solve Error for failing to execute sudo Command because Username is not in the sudoers file .

SELinux

  1. How to Temporarily disabled SELinux .
  2. How to Add Security Context Label for SELinux .

Cron Scheduler

  1. How to Run Shell Script as a Background Process .
  2. How to Add Date Attribute in the file name created using Cron Scheduler .

Samba Sharing Folder

  1. How to Install Samba in Linux Ubuntu .
  2. How to Reset Samba User Password via Command Line in Linux .
  3. How to Solve Samba Access Error : Session Setup Failed NT_STATUS_ LOGON_FAILURE .
  4. How to Copy file from Linux to Windows file and folder Sharing using Samba .
  5. How to Create Specific User for Samba file and folder Sharing .
  6. How to Mount Linux or Folder and File Sharing into Local Mount Point with Unique Password Character .
  7. How to Check Samba Configuration File using testparm Command .
  8. How to Mount Shared Folder in Linux using Samba .
  9. How to Access Folder and File Sharing from Linux using Samba .
  10. How to Add Samba User using smbpasswd Command .
  11. How to Install Samba Client .
  12. How to Configure Samba for Windows File Sharing .

SSH Remote Connection

  1. How to Solve SSH Access Denied because Invalid User .

Logical Volume Management

  1. How to Backup Logical Volume into a File .
  2. How to Create Logical Volume using lvcreate Command .
  3. How to Display Logical Volume Information using lvs Command .
  4. How to Display Volume Group Information using vgs Command .

APT Package Management

  1. How to Use apt to autoremove package in Ubuntu .
  2. How to Install Ubuntu Package via Proxy .
  3. How to Search Installed Package in Ubuntu .

Yum Package Management

  1. How to Recreate repository yum package file in CentOS .
  2. How to Install Package via Proxy using yum .

Firewall

  1. How to Install Firewall in Linux .
  2. How to Check Firewall State in Linux .