Difference between revisions of "Psql -q -X -U"
Jump to navigation
Jump to search
| (6 intermediate revisions by the same user not shown) | |||
| Line 2: | Line 2: | ||
[[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 -X]] | ||
| + | [[psql -U]] | ||
| + | |||
| + | * {{create extension}} | ||
| + | * {{psql}} | ||
Latest revision as of 14:52, 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
- CREATE EXTENSION pg_stat_statements, ~/brew/share/postgresql@17/extension/
- 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:
