Postgres Views - Revision history

Busk at 13:36, 20 February 2024

2024-02-20T13:36:35Z

Busk at 11:06, 20 February 2024

2024-02-20T11:06:12Z

Busk at 23:30, 19 February 2024

2024-02-19T23:30:42Z

Busk at 16:32, 19 February 2024

2024-02-19T16:32:10Z

Busk at 16:29, 19 February 2024

2024-02-19T16:29:51Z

Busk: Created page with "SECURITY INVOKER indicates that the function is to be executed with the privileges of the user that calls it. That is the default. SECURITY DEFINER specifies that the function..."

2024-02-19T16:15:06Z

Created page with "SECURITY INVOKER indicates that the function is to be executed with the privileges of the user that calls it. That is the default. SECURITY DEFINER specifies that the function..."

New page

SECURITY INVOKER indicates that the function is to be executed with the privileges of the user that calls it. That is the default. SECURITY DEFINER specifies that the function is to be executed with the privileges of the user that created it.

https://hevodata.com/learn/postgresql-stored-procedures/

← Older revision		Revision as of 13:36, 20 February 2024
Line 37:		Line 37:
	GRANT VIEW DEFINITION ON schema::[name_of_schema] TO [user];		GRANT VIEW DEFINITION ON schema::[name_of_schema] TO [user];
	```		```
		+
		+
		+	https://dba.stackexchange.com/questions/128229/execute-system-commands-in-postgresql

@@ Line 25: / Line 25: @@
 ```
 ALTER TABLE public.items ALTER COLUMN user_id SET DATA TYPE UUID USING (gen_random_uuid());
 ```

@@ Line 20: / Line 20: @@
             FROM public.users
            WHERE ((users.username)::text = CURRENT_USER)));
 ```

← Older revision		Revision as of 16:32, 19 February 2024
Line 4:		Line 4:
	https://hevodata.com/learn/postgresql-stored-procedures/		https://hevodata.com/learn/postgresql-stored-procedures/

		+	### Copy Table
		+	```
		+	CREATE TABLE users.chat as SELECT * FROM api.chat;
		+	```

−	CREATE ~~TABLE~~ users.chat as SELECT * FROM ~~api~~.~~chat~~;	+	### Create View
		+	```
		+	CREATE VIEW api.chat AS
		+	SELECT id,
		+	name,
		+	user_id,
		+	created_at
		+	FROM users.chat
		+	WHERE (user_id = ( SELECT users.id
		+	FROM public.users
		+	WHERE ((users.username)::text = CURRENT_USER)));
		+	```

← Older revision		Revision as of 16:29, 19 February 2024
Line 3:		Line 3:

	https://hevodata.com/learn/postgresql-stored-procedures/		https://hevodata.com/learn/postgresql-stored-procedures/
		+
		+
		+	CREATE TABLE users.chat as SELECT * FROM api.chat;