Celal Ak dolunay

This guide was created using Microsoft Windows 11 Pro

Useful information that developers should know, even when skimming content.

	-- list all functions in schema
	SELECT proname, prosrc
	FROM pg_catalog.pg_namespace n
	JOIN pg_catalog.pg_proc p
	ON pronamespace = n.oid
	WHERE nspname = 'public';

	-- list all tables in schema
	SELECT * FROM information_schema.tables
	WHERE table_schema = 'public'

	$userPath = $env:USERPROFILE
	$pathExclusions = New-Object System.Collections.ArrayList
	$processExclusions = New-Object System.Collections.ArrayList

	$pathExclusions.Add('C:\Windows\Microsoft.NET') > $null
	$pathExclusions.Add('C:\Windows\assembly') > $null
	$pathExclusions.Add($userPath + '\AppData\Local\Microsoft\VisualStudio') > $null
	$pathExclusions.Add('C:\ProgramData\Microsoft\VisualStudio\Packages') > $null
	$pathExclusions.Add('C:\Program Files (x86)\MSBuild') > $null
	$pathExclusions.Add('C:\Program Files (x86)\Microsoft Visual Studio') > $null