Ferramentas do usuário

Ferramentas do site


info:bandado:postgres:start

Diferenças

Aqui você vê as diferenças entre duas revisões dessa página.

Link para esta página de comparações

Ambos lados da revisão anterior Revisão anterior
Próxima revisão
Revisão anterior
info:bandado:postgres:start [2019/11/10 23:10]
Samuel [psql]
info:bandado:postgres:start [2019/11/21 12:00] (atual)
Samuel [999 Favoritos]
Linha 50: Linha 50:
   * [[https://​stackoverflow.com/​a/​2966352]]   * [[https://​stackoverflow.com/​a/​2966352]]
     * first and last occurrence of a character     * first and last occurrence of a character
 +  * [[https://​stackoverflow.com/​a/​27901920]]
 +    * //How to get definition/​source code of an aggregate in PostgreSQL?//​
 +  * [[https://​stackoverflow.com/​a/​11231965]]
 +    * Testar se um elemento está incluso em um array
  
  
Linha 57: Linha 61:
   * [[https://​plv8.github.io/​|V8 Engine Javascript Procedural Language add-on for PostgreSQL ]]   * [[https://​plv8.github.io/​|V8 Engine Javascript Procedural Language add-on for PostgreSQL ]]
   * [[https://​carto.com/​help/​working-with-data/​sql-stored-procedures/#​dynamic-plpgsql-functions]]   * [[https://​carto.com/​help/​working-with-data/​sql-stored-procedures/#​dynamic-plpgsql-functions]]
 +  * [[https://​access.crunchydata.com/​documentation/​postgresql96/​9.6.3/​plpgsql-control-structures.html#​TableOfContents20]]
 +    * //Obtaining Information About an Error// ​
  
  
Linha 72: Linha 78:
     * \df+ and \dy+ to view source code of functions and triggers     * \df+ and \dy+ to view source code of functions and triggers
   * [[http://​postgresguide.com/​utilities/​psql.html]] :!:   * [[http://​postgresguide.com/​utilities/​psql.html]] :!:
 +  * [[https://​stackoverflow.com/​a/​5331571]]
 +    * \o [FILE] send all query results to file or |pipe
  
 ==== pg_cron ==== ==== pg_cron ====
© 2019 por Samuel