1# How to ban an ip address from creating an account
 2
 3You also need to [delete the original account](./delete-account.md) because blocking ip only works for the signup flow in our TUI.
 4
 5Log into production db, then drop into psql
 6
 7```bash
 8cd pico
 9make psql
10```
11
12```sql
13insert into block_signups (ip, reason) values ('0.0.0.0', 'you spam too much');
14```
15
16The IP column is an [inet data type](https://www.postgresql.org/docs/current/datatype-net-types.html#DATATYPE-INET) to enforce correct structure.