Difference between revisions of "Psql -q -X -U"
Jump to navigation
Jump to search
| Line 5: | Line 5: | ||
[[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]]; |
| − | create extension postgres_fdw; | + | create extension [[postgres_fdw]]; |
| − | grant usage on foreign data wrapper postgres_fdw to <USERNAME>; | + | [[grant usage on foreign data wrapper]] [[postgres_fdw]] to <USERNAME>; |
[[EOF]] | [[EOF]] | ||
Revision as of 14:51, 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:
