~/.psqlrc example

.psqlrc

-- vi: ft=pgsql

-- Nice prompt:
-- Modified from here: https://stackoverflow.com/a/19155772
-- Docs are here: https://www.postgresql.org/docs/9.3/app-psql.html#APP-PSQL-PROMPTING
\set PROMPT1 '%[%033[33m%]%n%[%033[0m%]@%[%033[1;33m%]%/%[%033[0m%]%R '
\set PROMPT2 :PROMPT1

-- Nuvocargo specific changes
do $$ begin if exists (select 1 from pg_catalog.pg_namespace where nspname = 'airtable') then
  set search_path = pg_temp, "$user", public, airtable;

  create temp view sync_info as
    select
      now(),
      completed_at,
      now()-completed_at,
      duration_last
    from airtable._sync_meta;
end if; end $$ language 'plpgsql';