PostgreSQL

example

 #!/bin/bash
 CAS=`date +"%d.%m.%y %T"`
 echo "Zacetek dumpanja: $CAS"
 echo "Zacetek dumpanja: $CAS" >> /var/log/postdump.err
 cd /var/backup/postgres
 rm -f *.sql.gz
 cd /var/lib/postgresql
 
 for baza in `/bin/su -c "psql -l" postgres | tr -d ' ' | egrep -v "Name|-|Listofdatabases|rows|template0" | cut -f1 -d '|' | sed -e   '/^$/d'`
 do
    echo "Obdelujem bazo $baza"
    /bin/su -c "pg_dump $baza > $baza.sql" postgres
    gzip -f --best $baza.sql
   mv $baza.sql.gz /var/backup/postgres
 done
 
 CAS=`date +"%d.%m.%y %T"`
 echo "Konec: $CAS"
 echo "Konec: $CAS" >> /var/log/postdump.err
 echo
 echo >> /var/log/postdump.err

 CREATE TABLE example_table (
      first_name VARCHAR(100)
          CONSTRAINT check_first_name
         ( first_name ~* '^[a-z]+$')
 );

see: this