Make synonym replacement more descriptive

Improve synonym section with more explicit examples, like:

```sql
CREATE OR REPLACE SYNONYM user2.table1 FOR user1.table1;
SELECT * FROM table1; -- as user2
```

becomes

```sql
SET search_path = "$user", user1, public;
SELECT * FROM table1;
```