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

From wikieduonline
Jump to navigation Jump to search
Line 3: Line 3:
  
 
   [[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;
 
  create extension btree_gist;
 
  create extension btree_gist;

Revision as of 14:46, 19 December 2024

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


psql -X
psql -U

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: