SET SESSION AUTHORIZATION jane;
SET search_path = schema1,schema2, schema3;
SELECT * FROM any_table_in_schema_1_2_or_3;
Implicit Casting in PostgreSQL
CREATE CAST(integer AS character varying) WITH INOUT AS IMPLICIT;
CREATE CAST (character varying AS integer) WITH INOUT AS IMPLICIT;
Integer Array Casting in PostgreSQL
-- Rule: "_DELETE" ON sometable
-- DROP RULE "_DELETE" ON sometable;
CREATE OR REPLACE RULE "_DELETE" AS
ON DELETE TO sometable DO INSTEAD DELETE FROM _sometable
WHERE _sometable.account_id = old.account_id AND (old.domain_id = ANY ((( SELECT get_visible_domains('DELETE'::text) AS get_visible_domains)::integer[])));
Tracing PostgreSQL Error Log
/pgsql/dev-db/tail -f postgresql.log
Reset Sequence using PostgreSQL
SELECT setval('YOUR_SEQUENCE_NAME', (SELECT MAX(id) FROM YOUR_TABLE_NAME));