Difference between revisions of "Psql -q -X -U"
Jump to navigation
Jump to search
Line 1: | Line 1: | ||
{{lc}} | {{lc}} | ||
[[psql -q]] -X -U | [[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}} | {{psql}} |
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: