Postgres - Revision history

ViciousCarnivore: /* Create a user */

2023-12-18T06:09:52Z

Create a user

2022-12-30T14:24:25Z

Resources

2022-12-19T07:02:46Z

Resources

2022-12-19T07:02:16Z

2022-12-18T21:59:26Z

Basic User Access

2022-12-18T21:56:04Z

Usage

2022-12-14T06:05:10Z

Basic User Access

2022-12-14T05:18:49Z

2021-04-15T21:20:51Z

Usage

2021-04-15T16:40:10Z

Usage

@@ Line 99: / Line 99: @@
 Note that if you have an existing db, you might want to add ownership to this user, or r/w
 permissions.
 ==Resources==

← Older revision		Revision as of 14:24, 30 December 2022
Line 103:		Line 103:
	* https://en.wikibooks.org/wiki/PostgreSQL		* https://en.wikibooks.org/wiki/PostgreSQL
	* https://wiki.debian.org/PostgreSql		* https://wiki.debian.org/PostgreSql
		+	* http://web.archive.org/web/20221129022928/https://blog.frankel.ch/poor-man-api/ - postgres, easy to deploy http api. Note that in golang, there are also quite easy ways to create an http server. Python as well, i'm sure.

← Older revision		Revision as of 07:02, 19 December 2022
Line 102:		Line 102:
	==Resources==		==Resources==
	* https://en.wikibooks.org/wiki/PostgreSQL		* https://en.wikibooks.org/wiki/PostgreSQL
		+	* https://wiki.debian.org/PostgreSql

← Older revision		Revision as of 07:02, 19 December 2022
Line 99:		Line 99:
	Note that if you have an existing db, you might want to add ownership to this user, or r/w		Note that if you have an existing db, you might want to add ownership to this user, or r/w
	permissions.		permissions.
		+
		+	==Resources==
		+	* https://en.wikibooks.org/wiki/PostgreSQL

@@ Line 12: / Line 12: @@
 ==Basic User Access==
   su - postgres
   createuser --pwprompt user
@@ Line 21: / Line 22: @@
   ALTER USER user CREATEDB;
 otherwise, the user account can't create a db (though he can delete).
-Finally, as the normal user account you can:
+Finally, as the logged in user account you can:
   psql -d postgres -c "DROP DATABASE   mydb;"
   psql -d postgres -c "CREATE DATABASE mydb;"
 ==Bash create/delete==

@@ Line 6: / Line 6: @@
   \l  - list databases
   \c  - connect to db
 Since PostgreSQL 10, psql has \gx which is equal to mysql \G
   select * from sometable \gx

← Older revision		Revision as of 06:05, 14 December 2022
Line 24:		Line 24:
	psql -d postgres -c "CREATE DATABASE mydb;"		psql -d postgres -c "CREATE DATABASE mydb;"

		+	==Bash create/delete==
		+	<pre>
		+	######## db_create.sh
		+	psql -d postgres -c "CREATE DATABASE mydb;"
		+	psql -d mydb -c " CREATE TABLE entry ( \
		+	id SERIAL PRIMARY KEY, \
		+	entryvalue TEXT \
		+	);"

		+
		+	######## db_delete.sh
		+	psql -d postgres -c "DROP DATABASE mydb;"
		+	</pre>
		+	I don't understand why sometimes you must specify -d postgres
		+	and sometimes you can specify the specific db. In practice, I
		+	suppose it isn't important.

	==Backup / Restore DB==		==Backup / Restore DB==

@@ Line 9: / Line 9: @@
   select * from sometable \gx
 ref:stackex
 ==Backup / Restore DB==

@@ Line 1: / Line 1: @@
 ==Usage==
 Since PostgreSQL 10, psql has \gx which is the exact equivalent of mysql's \G
   select * from sometable \gx