# Postgresql String Extension

A better way of handling string manipulation and transformations in Postgresql.

Function api and behavior is inspired by those available in the Laravel web framework: https://laravel.com/docs/8.x/helpers#strings-method-list

## Installation
```
git clone git@github.com:abumni/pg_str
cd pg_str
cargo pgx package # run cargo install pgx first
sudo make install # adjust Makefile if using different version of postgresql than 13.
```
This puts the binaries and sql into the right folder location. Next you need to create the extension in postgresql:

```
psql
> create extension pg_str; # installs functions in a schema named 'str'
> select str.markdown('# Hello '
|| str.snake('pg str')
|| '- ~~using programming language for str manipulations~~ 
- **do it all in postgresql** ');
```

## API
- [] after
- [] afterLast
- [] ascii
- [] before
- [] beforeLast
- [] between
- [x] camel 
- [x] contains
- [x] containsAll
- [] endsWith
- [] finish
- [] headline
- [] is
- [x] isAscii
- [] isUuid
- [x] kebab 
- [] length
- [] limit
- [x] lower 
- [x] markdown 
- [] mask
- [] orderedUuid
- [] padBoth
- [] padLeft
- [] padRight
- [x] plural 
- [] pluralStudly
- [] random
- [] remove
- [x] replace
- [] replaceArray
- [] replaceFirst
- [] replaceLast
- [] reverse
- [x] singular 
- [x] slug 
- [x] snake 
- [] start
- [] startsWith
- [x] studly 
- [] substr
- [] substrCount
- [] substrReplace
- [x] title 
- [] toHtmlString
- [] ucfirst
- [x] upper 
- [] uuid
- [] wordCount
- [] words