Difference between revisions of "Psql -q -X -U"

From wikieduonline
Jump to navigation Jump to search
Line 2: Line 2:
 
  [[psql -q]] -X -U
 
  [[psql -q]] -X -U
  
   [[psql -q]] -X -U <SUPERUSER> graph-node <<EOF
+
   [[psql -q]] -X -U <SUPERUSER> graph-node <<[[EOF]]
 
  create extension pg_trgm;
 
  create extension pg_trgm;
 
  create extension pg_stat_statements;
 
  create extension pg_stat_statements;

Revision as of 07:42, 13 July 2023

psql -q -X -U
 psql -q -X -U <SUPERUSER> graph-node <<EOF
create extension pg_trgm;
create extension pg_stat_statements;
create extension btree_gist;
create extension postgres_fdw;
grant usage on foreign data wrapper postgres_fdw to <USERNAME>;
EOF


PostgreSQL: psql, .psqlrc, .pgpass, $HOME/.pg service.conf, -U, -W, -d, meta-commands: \du, \dg, \ddp, \dp, \list, \dn, \dt, \c, \l, \di, \q, show users, show, su - postgres, psql -c, \?, \connect, \conninfo, --version, --help, PL/pgSQL

Advertising: