PostgreSQL: Difference between revisions
No edit summary |
|||
| Line 29: | Line 29: | ||
*https://www.tutorialspoint.com/postgresql/index.htm | *https://www.tutorialspoint.com/postgresql/index.htm | ||
*http://www.postgresqltutorial.com/ | *http://www.postgresqltutorial.com/ | ||
==Documentation== | |||
===curious cross=== | |||
https://www.postgresql.org/docs/12/functions-matching.html#FUNCTIONS-SIMILARTO-REGEXP | |||
"The SIMILAR TO operator returns true or false depending on whether its pattern matches the given string. It is similar to LIKE, except that it interprets the pattern using the SQL standard's definition of a regular expression. SQL regular expressions are a curious cross between LIKE notation and common regular expression notation." | |||
Revision as of 2022-09-28T13:05:19
Name
- postgresql / PostgreSQL
- postgresql.org
- pgsql - PL/pgSQL
- mod_pgsql
- pdo_pgsql
- postgres
- psql
- pg
- pgloader
- https://www.pgadmin.org/
Creating cluster
https://www.postgresql.org/docs/10/static/creating-cluster.html
"/usr/local/pgsql/data or /var/lib/pgsql/data are popular"
- in Ubuntu 'apt-get install postgresql' creates /var/lib/postgresql/
initdb not found
- https://askubuntu.com/questions/371737/install-postgresql-why-is-initdb-unavailable
- https://superuser.com/questions/513386/setting-up-postgresql-gives-error-sudo-initdb-command-not-found
Command line
psql -e db < example.sql
Link
Documentation
curious cross
https://www.postgresql.org/docs/12/functions-matching.html#FUNCTIONS-SIMILARTO-REGEXP "The SIMILAR TO operator returns true or false depending on whether its pattern matches the given string. It is similar to LIKE, except that it interprets the pattern using the SQL standard's definition of a regular expression. SQL regular expressions are a curious cross between LIKE notation and common regular expression notation."