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 [2020/06/15 11:10] (atual)
Samuel [Stack-Overflow]
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
 +  * [[https://severalnines.com/database-blog/backup-postgresql-using-pgdump-and-pgdumpall]]
 +  * [[https://dba.stackexchange.com/a/16427]]
 +    * Finalizando conexoes de um determinado banco de dados
 +  * [[https://www.compose.com/articles/storing-network-addresses-using-postgresql/]]
 +  * [[https://www.enterprisedb.com/blog/getting-most-out-applicationname]]
 +  * [[https://stackoverflow.com/a/57785237]]
 +    * function to insert png as bytea column field
 +  * [[https://stackoverflow.com/a/26228074]]
 +    * encode a bytea field column as base64 to load an image in website
 +  * [[https://www.enterprisedb.com/blog/getting-most-out-applicationname]]
  
  
 +
 +==== pgAdmin4 ====
 +
 +  * [[https://askubuntu.com/a/1165878]]
 +    * pgAdmin4 Flask permission denied para a pasta sessions
 +      * sinceramente não sei se ajudou...
 +
 +  * [[http://www.solvista.nl/2019/04/13/server-deployment-pgadmin-4-5-on-windows-server-2019-and-apache-with-mod_wsgi/]]
 +    * Na seção final "A bumpy ride" me ajudou a configurar devidamente o arquivo pgAdmin4.wsgi pois me levou a:
 +      * [[https://flask.palletsprojects.com/en/1.1.x/deploying/mod_wsgi/#working-with-virtual-environments]]
 +        * e aí sim... resolveu... :-?
 +
 +==== pgAudit ====
 +
 +  * [[https://www.bantrain.com/how-to-enable-audit-logs-on-aws-rds-for-postgres-9/]]
 +  * [[https://severalnines.com/database-blog/postgresql-audit-logging-best-practices]]
 +  * [[https://aws.amazon.com/blogs/database/working-with-rds-and-aurora-postgresql-logs-part-1/]]
  
 ==== plpgsql ==== ==== plpgsql ====
Linha 57: Linha 88:
   * [[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 65: Linha 98:
   * [[http://www.postgresqltutorial.com/psql-commands/]]   * [[http://www.postgresqltutorial.com/psql-commands/]]
   * [[https://blog.2ndquadrant.com/how-to-safely-change-the-postgres-user-password-via-psql/]]   * [[https://blog.2ndquadrant.com/how-to-safely-change-the-postgres-user-password-via-psql/]]
-  * [[https://stackoverflow.com/questions/3049864/transfer-data-between-databases-with-postgresql]] 
-    * //pg_dump// com //psql// 
-  * [[https://stackoverflow.com/a/38341540]] 
-    * e [[https://stackoverflow.com/a/3526243]] 
-    * e [[https://stackoverflow.com/a/12277678]] 
-    * \df+ and \dy+ to view source code of functions and triggers 
   * [[http://postgresguide.com/utilities/psql.html]] :!:   * [[http://postgresguide.com/utilities/psql.html]] :!:
 +  * [[https://chartio.com/resources/tutorials/how-to-list-databases-and-tables-in-postgresql-using-psql/]]
  
 ==== pg_cron ==== ==== pg_cron ====
Linha 105: Linha 133:
   * [[https://stackoverflow.com/a/13113623]]   * [[https://stackoverflow.com/a/13113623]]
     * formatting for display to the user, use to_char     * formatting for display to the user, use to_char
 +  * [[https://stackoverflow.com/a/32957982]]
 +    * How to insert new line in PostgreSQL
 +  * [[https://stackoverflow.com/a/17461681]]
 +    * How to disconnect connections who not allowed drop database
 +  * [[https://stackoverflow.com/a/982821]]
 +    * remove character using RIGHT/LEFT
 +  * [[https://stackoverflow.com/a/8585472]]
 +    * split csv...
 +  * [[https://stackoverflow.com/a/1981366]]
 +    * replace 2 or more spaces with single...
 +  * [[https://stackoverflow.com/a/19975464]]
 +    * check if string is a number... (regex)
  
   * **PostGIS**   * **PostGIS**
Linha 115: Linha 155:
     * [[https://stackoverflow.com/a/43781719]]     * [[https://stackoverflow.com/a/43781719]]
       * how to check type of value in postgres (**pg_typeof**)       * how to check type of value in postgres (**pg_typeof**)
 +    * [[https://stackoverflow.com/a/47483954]]
 +      * Parâmetros varchar com tamanho da string
 +        * na assinatura da funcao são ignorados
  
   * **psql**   * **psql**
     * [[https://stackoverflow.com/questions/22715053/postgresql-view-schema-privileges]]     * [[https://stackoverflow.com/questions/22715053/postgresql-view-schema-privileges]]
     * [[https://stackoverflow.com/questions/38116476/redirecting-stdout-of-eof]]     * [[https://stackoverflow.com/questions/38116476/redirecting-stdout-of-eof]]
 +    * [[https://stackoverflow.com/a/30338538]]
 +      * Copying PostgreSQL database to another server    
 +    * [[https://stackoverflow.com/a/39487582]]
 +      * pg_dump from one server to a psql point to another server
 +    * [[https://stackoverflow.com/questions/3049864/transfer-data-between-databases-with-postgresql]]
 +      * //pg_dump// com //psql//
 +    * [[https://stackoverflow.com/a/38341540]]
 +      * e [[https://stackoverflow.com/a/3526243]]
 +      * e [[https://stackoverflow.com/a/12277678]]
 +      * \df+ and \dy+ to view source code of functions and triggers
 +    * [[https://stackoverflow.com/a/5331571]]
 +      * \o [FILE] send all query results to file or |pipe
 +
© 2020 por Samuel