PostgreSQL - Revision history

Tobiasco at 2025-11-28T13:39:01

2025-11-28T13:39:01Z

← Older revision		Revision as of 2025-11-28T13:39:01
Line 76:		Line 76:
	==15 schema public==		==15 schema public==
	"Nennenswert ist zudem, dass User aus Sicherheitsgründen im public beziehungsweise Default-Schema keine Tabellen mehr mit CREATE erzeugen dürfen." https://www.heise.de/news/Datenbank-PostgreSQL-15-fuehrt-endlich-MERGE-ein-7308296.html		"Nennenswert ist zudem, dass User aus Sicherheitsgründen im public beziehungsweise Default-Schema keine Tabellen mehr mit CREATE erzeugen dürfen." https://www.heise.de/news/Datenbank-PostgreSQL-15-fuehrt-endlich-MERGE-ein-7308296.html

			== unistr ==
			https://pgpedia.info/u/unistr.html
			Execution with an invalid Unicode escape:
			postgres=# SELECT unistr('\+10000');
			ERROR: invalid Unicode escape
			HINT: Unicode escapes must be \XXXX, \+XXXXXX, \uXXXX, or \UXXXXXXXX.

Tobiasco: Tobiasco moved page Postgresql to PostgreSQL

2023-04-04T18:07:55Z

Tobiasco moved page Postgresql to PostgreSQL

← Older revision	Revision as of 2023-04-04T18:07:55
(No difference)

Tobiasco at 2022-10-14T13:05:46

2022-10-14T13:05:46Z

← Older revision		Revision as of 2022-10-14T13:05:46
Line 74:		Line 74:

	"Some locale categories must have their values fixed when the database is created. You can use different settings for different databases, but once a database is created, you cannot change them for that database anymore. LC_COLLATE and LC_CTYPE are these categories. They affect the sort order of indexes, so they must be kept fixed, or indexes on text columns would become corrupt. (But you can alleviate this restriction using collations, as discussed in Section 23.2.) The default values for these categories are determined when initdb is run, and those values are used when new databases are created, unless specified otherwise in the CREATE DATABASE command."		"Some locale categories must have their values fixed when the database is created. You can use different settings for different databases, but once a database is created, you cannot change them for that database anymore. LC_COLLATE and LC_CTYPE are these categories. They affect the sort order of indexes, so they must be kept fixed, or indexes on text columns would become corrupt. (But you can alleviate this restriction using collations, as discussed in Section 23.2.) The default values for these categories are determined when initdb is run, and those values are used when new databases are created, unless specified otherwise in the CREATE DATABASE command."
			==15 schema public==
			"Nennenswert ist zudem, dass User aus Sicherheitsgründen im public beziehungsweise Default-Schema keine Tabellen mehr mit CREATE erzeugen dürfen." https://www.heise.de/news/Datenbank-PostgreSQL-15-fuehrt-endlich-MERGE-ein-7308296.html

Tobiasco: /* LC_COLLATE and LC_CTYPE */

2022-10-07T12:58:24Z

LC_COLLATE and LC_CTYPE

← Older revision		Revision as of 2022-10-07T12:58:24
Line 69:		Line 69:
	tidb_all=#		tidb_all=#
	</pre>		</pre>

			==LC_COLLATE and LC_CTYPE==
			https://www.postgresql.org/docs/11/locale.html

			"Some locale categories must have their values fixed when the database is created. You can use different settings for different databases, but once a database is created, you cannot change them for that database anymore. LC_COLLATE and LC_CTYPE are these categories. They affect the sort order of indexes, so they must be kept fixed, or indexes on text columns would become corrupt. (But you can alleviate this restriction using collations, as discussed in Section 23.2.) The default values for these categories are determined when initdb is run, and those values are used when new databases are created, unless specified otherwise in the CREATE DATABASE command."

Tobiasco at 2022-10-07T11:50:20

2022-10-07T11:50:20Z

← Older revision		Revision as of 2022-10-07T11:50:20
Line 43:		Line 43:
	from t		from t
	where i > 1) to stdout \g q.txt		where i > 1) to stdout \g q.txt

			==pgloader==
			<pre>
			root@bionic:/var/log/apache2# psql -d anna
			psql (10.5 (Ubuntu 10.5-0ubuntu0.18.04))
			Type "help" for help.

			anna=# DROP DATABASE tidb_all;
			DROP DATABASE
			anna=# CREATE DATABASE tidb_all;
			CREATE DATABASE
			anna=# \q

			root@bionic:/var/log/apache2# pgloader
			mysql://root:XXXXX@localhost/tidb_all pgsql:///tidb_all

			(dann tablle siehe unten)

			root@bionic:/var/log/apache2# psql -d tidb_all
			psql (10.5 (Ubuntu 10.5-0ubuntu0.18.04))
			Type "help" for help.

			tidb_all=# REASSIGN OWNED BY root TO tobiasco;
			REASSIGN OWNED
			tidb_all=#
			</pre>

Tobiasco at 2022-09-28T13:54:41

2022-09-28T13:54:41Z

← Older revision		Revision as of 2022-09-28T13:54:41
Line 34:		Line 34:
	https://www.postgresql.org/docs/12/functions-matching.html#FUNCTIONS-SIMILARTO-REGEXP		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."		"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."

			==COPY==
			mulitline to file
			https://www.manniwood.com/2021_11_13/multiline_copy_command.html
			# copy (
			select i,
			d
			from t
			where i > 1) to stdout \g q.txt

Tobiasco at 2022-09-28T12:05:19

2022-09-28T12:05:19Z

← Older revision		Revision as of 2022-09-28T12:05:19
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."

Tobiasco: /* Name */

2018-09-01T18:37:52Z

Name

← Older revision		Revision as of 2018-09-01T18:37:52
Line 11:		Line 11:
	#pg		#pg
	##pgloader		##pgloader
			##https://www.pgadmin.org/

	==Creating cluster==		==Creating cluster==

Tobiasco: /* Name */

2018-09-01T18:37:15Z

Name

← Older revision		Revision as of 2018-09-01T18:37:15
Line 9:		Line 9:
	#psql		#psql
	##https://www.postgresql.org/docs/10/static/app-psql.html		##https://www.postgresql.org/docs/10/static/app-psql.html
			#pg
			##pgloader

	==Creating cluster==		==Creating cluster==

Tobiasco: /* Link */

2018-08-31T10:46:15Z

Link

← Older revision		Revision as of 2018-08-31T10:46:15
Line 25:		Line 25:
	==Link==		==Link==
	*https://www.tutorialspoint.com/postgresql/index.htm		*https://www.tutorialspoint.com/postgresql/index.htm
			*http://www.postgresqltutorial.com/