-- Configs:
SELECT name, setting FROM pg_settings WHERE category = 'File Locations';

ALTER DATABASE shop SET search_path TO "$user", public, tool, client, admin, product, orders, extension, log; -- Global
SHOW search_path;
SET search_path TO public, smart;   -- Put `intarray' to smart for separating my own functions more clearly

-- Copy data from file 
\COPY public.rental (rental_id, rental_date, inventory_id, customer_id, return_date, staff_id, last_update) 
FROM '/Users/Can/Desktop/dvdrental/3077.dat';

-- CSV 
\COPY persons(first_name,last_name,dob,email) 
FROM '/Users/Can/Desktop/persons.csv' DELIMITER ',' CSV HEADER;

\dv => List all View
\dt => List all Table
\ds => List all Sequence
\dn => List all Schemas

\dT+ enum-type-name  --\dT+ log_action 

SELECT TIMEOFDAY();
SELECT CURRENT_TIME;


SELECT format('%I.%I(%s)', ns.nspname, p.proname, oidvectortypes(p.proargtypes)) 
FROM pg_proc p INNER JOIN pg_namespace ns ON (p.pronamespace = ns.oid)
WHERE ns.nspname = 'public' and p.proname LIKE 'admin%';


SELECT format('ALTER FUNCTION %I.%I(%s)
  SET SCHEMA admin; ', ns.nspname, p.proname, oidvectortypes(p.proargtypes)) 
FROM pg_proc p INNER JOIN pg_namespace ns ON (p.pronamespace = ns.oid)
WHERE ns.nspname = 'public' and p.proname LIKE 'admin*';

SELECT *
FROM pg_proc p INNER JOIN pg_namespace ns ON (p.pronamespace = ns.oid)
WHERE ns.nspname = 'public';


\Copy (SELECT format('ALTER FUNCTION %I.%I(%s) SET SCHEMA admin;', ns.nspname, p.proname, oidvectortypes(p.proargtypes)) FROM pg_proc p INNER JOIN pg_namespace ns ON (p.pronamespace = ns.oid) WHERE ns.nspname = 'public' and p.proname LIKE 'admin%') TO '/Users/Can/Desktop/admin.txt';

\Copy (SELECT format('ALTER FUNCTION %I.%I(%s) SET SCHEMA product;', ns.nspname, p.proname, oidvectortypes(p.proargtypes)) FROM pg_proc p INNER JOIN pg_namespace ns ON (p.pronamespace = ns.oid) WHERE ns.nspname = 'public' and p.proname LIKE 'product%') TO '/Users/Can/Desktop/product.txt';