set path postgres

• SQL
• 0
• 0
• 1308

update using select (mysql)

• SQL
• 2
• 2
• 1922

update using select (postgres)

• SQL
• 0
• 2
• 1295

list all indexes from tables (Postgresql)

• SQL
• 0
• 2
• 4241

Simple word counter using postgres

• SQL
• 0
• 2
• 1397

Generating random integers in the range x - y (postgres)

• SQL
• 0
• 2
• 1415

Assigns random values from a set to a table column (postgres)

• SQL
• 0
• 3
• 1639

migration mysql to postgres (pgloader)

• SQL
• 0
• 1
• 1763

migration example usign sakila db (pgloader)

• SQL
• 0
• 1
• 1460

using COPY from postgres to load data from csv

• Bash
• 0
• 0
• 1299

inserting multiple lines using multiple queries

• SQL
• 0
• 1
• 1259

Creating a table using another two unrelated tables (postgres)

• SQL
• 0
• 0
• 1344

(Postgres) Disconnect all users except yours

• SQL
• 2
• 0
• 1404

(Postgres) Alter database name

• SQL
• 0
• 2
• 1336

disable fk restriction (mysql)

• MySQL
• 0
• 0
• 1590

list all schemas (postgres)

• SQL
• 0
• 5
• 1739

dump only tables from postgres (cli)

• Bash
• 0
• 9
• 1290

Show all columns for a specified table (Postgres)

• Bash
• 0
• 8
• 1319

delete duplicated records mysql

• MySQL
• 0
• 7
• 1461

create csv from sql on postgres

• MySQL
• 0
• 8
• 1352

Find which tables 2 schemas differ (postgres)

• SQL
• 0
• 12
• 1403

Create user with all access (MySQL)

• MySQL
• 0
• 10
• 1368

Execute sql file to specific schema with psql

• Bash
• 0
• 1
• 2274

Dump lines from tables with mysqldump (mysql)

• MySQL
• 0
• 4
• 1375

Pretty print on mysql cli

• MySQL
• 0
• 0
• 1342