PostgreSql-Snippets

KO | EN

gitlite — search

#react #llm #golang #deep-learning #linux #docker #java #kubernetes #awesome-list #security #pytorch #mcp #openai #open-source

PostgreSql-Snippets

(★ 19)

⌗ Learn PostgreSql.

PostgreSql-Snippets 최신버젼 다운로드

최종 버전 다운로드 (.zip)

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

# PostgreSql-Snippets

[How to Run PostgreSQL Using Docker](https://towardsdatascience.com/how-to-run-postgresql-using-docker-15bf87b452d4)

[How to Connect to a PostgreSQL Database With a Python Serverless Function](https://towardsdatascience.com/how-to-connect-to-a-postgresql-database-with-a-python-serverless-function-f5f3b244475)

[How to Connect to a Heroku Postgres Database With pgAdmin Using Docker](https://towardsdatascience.com/how-to-connect-to-a-heroku-postgres-database-with-pgadmin4-using-docker-6ac1e423ae66)

[How to Run PostgreSQL and pgAdmin Using Docker](https://towardsdatascience.com/how-to-run-postgresql-and-pgadmin-using-docker-3a6a8ae918b5)

```shell
brew services start postgresql
createuser -s postgres
brew services restart postgresql

brew unlink postgresql@13
brew link postgresql@12

brew info postgresql
```

```shell
psql -U mahbubzaman -d postgres
ALTER ROLE postgres WITH SUPERUSER;
```

```sql
brew services restart postgresql@14

psql postgres

# List of Roles 
\du

Role name  |                         Attributes                         | Member of 
-------------+------------------------------------------------------------+-----------
 mahbubzaman | Superuser | {}
 postgres    | Superuser | {}

# List of databases
\l

CREATE DATABASE DB_NAME;

# Select the db
\c DB_NAME

# Show tables
\dt

# column listing
\d table_name;

# Quit
\q

# Export CSV
COPY articles TO '/Users/xyz/Desktop/abc/article.csv' DELIMITER ',' CSV HEADER;

# Import CSV
COPY articles FROM '/Users/xyz/Desktop/abc/article.csv' DELIMITER ',' CSV HEADER;
```

# Conncetion pooler

- https://www.pgbouncer.org/
- https://pgpool.net/mediawiki/index.php?title=Main_Page

# Resources

- https://pgtune.leopard.in.ua/

PostgreSql-Snippets

PostgreSql-Snippets 최신버젼 다운로드

오늘의 추천 프로젝트

Was this content helpful?

Recent Feedback

PostgreSql-Snippets

PostgreSql-Snippets 최신버젼 다운로드

오늘의 추천 프로젝트

Was this content helpful?

Recent Feedback

Download README