Queries in SQL (PostgreSQL)

MD5 hash

SELECT * FROM TABLE WHERE md5(field::text) = 'text to be hashed'

LIKE query in psycopg2

arg = "TEXT TO BE FOUND"
cursor.execute("""SELECT * FROM my_table WHERE my_field LIKE '%%' || %s || '%%' """, (arg,))

SELECT FROM LIST

SELECT * FROM table WHERE field IN ('val1', 'val2', 'val3', 'val4', 'val5')

FIND DUPLICATED VALUES

SELECT
    field1, field2, COUNT(*)
FROM
    table
GROUP BY
    field1, field2
HAVING 
    COUNT(*) > 1

CONVERT DATE TO STRING

SELECT to_char(field1,'dd/mm/yyyy-hh:mm') AS my_date FROM my_schema.my_table WHERE field2=1234

QUERY BY DATE

SELECT *
FROM table
WHERE update_date >= 'yyyy-mm-dd'::date

LIST TABLESPACES IN PSQL SHELL

\db+

DROP TABLESPACE

DROP TABLESPACE [ IF EXISTS ] tablespacename

paulozullu/SQL.MD