> For the complete documentation index, see [llms.txt](https://dev117uday.gitbook.io/databases/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://dev117uday.gitbook.io/databases/sql/getting-started/administration-task.md).

# PgAdmin Tool

## Creating New User

![image](https://4266709838-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MguJ2NLZYzXs1aLLRCO%2Fuploads%2Fgit-blob-0ec71d39e3306cb3d90e26e1f9f4505683c4a059%2Fcreate_user.gif?alt=media)

### **Options**

* **General**
  * Name : username
  * Comment : description
* **Definition**
  * Password : user password
  * Account Expires
  * Connection Limit : number of connections that user can have to DB, default -1

**Refer to documentation for more details**

* <https://www.pgadmin.org/docs/pgadmin4/development/role\\_dialog.html>

## Query Editor

![image](https://4266709838-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MguJ2NLZYzXs1aLLRCO%2Fuploads%2Fgit-blob-98e0c5bcccb1333aa0f161140bf32c50f034d377%2Fquery-editor.gif?alt=media)

## Load Data using pgAdmin4

![image](https://4266709838-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MguJ2NLZYzXs1aLLRCO%2Fuploads%2Fgit-blob-437d77f591be01d672bf01180af00531424b3e99%2Foutput.gif?alt=media)