PostgreSql cheat sheet
0 likes380 views
This document provides a cheat sheet for PostgreSQL, listing useful commands for logging in, querying databases and tables, managing users and roles, monitoring performance, and more. It also includes examples of common queries for listing objects, casting data types, and analyzing query plans.
1 of 3
Download to read offline
![dt .:Listtablesfromall
schemas(if*.*isomitted
willonlyshow
SEARCH_PATHones)
dT+:Listalldatatypes
dv:Listviews
dx:Listallextensions
installed
df+__function__:Show
functionSQLcode.
x:Pretty-formatquery
resultsinsteadofthenot-
so-usefulASCIItables
copy(SELECT*FROM
__table_name__)TO
'file_path_and_name.csv'
WITHCSV:Exportatable
asCSV
des+:Listallforeign
servers
dE[S+]:Listallforeign
tables
UserRelated:
du:Listusers
du__username__:Lista
usernameifpresent.
createrole__test1__:
Createarolewithan
existingusername.
createrole__test2__
noinheritloginpassword
__passsword__;:Createa
rolewithusernameand
password.
setrole__test__;:Change
roleforcurrentsessionto
__test__.
grant__test2__to
__test1__;:Allow__test1__
tosetitsroleas__test2__.
deu+:Listalluser
mappingonserver
u %d %a ' s WHERE tablename='__ta
ble_name__' AND scheman
ame='__schema_name__';
Getallindexesfromalltables
ofaschema:
SELECT
t.relname AS table_n
ame,
i.relname AS index_n
ame,
a.attname AS column_
name
FROM
pg_class t,
pg_class i,
pg_index ix,
pg_attribute a,
pg_namespace n
WHERE
t.oid = ix.indrelid
AND i.oid = ix.index
relid
AND a.attrelid = t.o
id
AND a.attnum = ANY(i
x.indkey)
AND t.relnamespace
= n.oid
AND n.nspname = 'ka
rtones'
ORDER BY
t.relname,
i.relname
Executiondata
SELECT datname, applica
tion_name, pid, backend
_start, query_start, st
ate_change, state, quer
y
FROM pg_stat_activit
y
WHERE datname='__data
base_name__';
Getallqueriesfromalldbs
waitingfordata(mightbe
hung)
SELECT * FROM pg_stat_a
ctivity WHERE waiting
='t'
Currentlyrunningquerieswith
processpid:
?
?](https://image.slidesharecdn.com/postgresqlcheatsheet-200609155326/85/PostgreSql-cheat-sheet-2-320.jpg)
![CheatSheetMaker.com SimpleCheatSheet.com
SELECT pg_stat_get_back
end_pid(s.backendid) A
S procpid,
pg_stat_get_backend_ac
tivity(s.backendid) AS
current_query
FROM (SELECT pg_stat_ge
t_backend_idset() AS ba
ckendid) AS s;
Casting
CAST(columnAStype)
orcolumn::type
'__table_name__'::regclass::oid:
Getoidhavingatable
name
Queryanalysis
EXPLAIN__query__:see
thequeryplanforthe
givenquery
EXPLAINANALYZE
__query__:seeand
executethequeryplan
forthegivenquery
ANALYZE[__table__]:
collectstatistics
?Generatingrandomdata
INSERT INTO some_table
(a_float_value) SELECT
random() * 100000 FROM
generate_series(1, 1000
000) i;
?
?](https://image.slidesharecdn.com/postgresqlcheatsheet-200609155326/85/PostgreSql-cheat-sheet-3-320.jpg)
Ad
Recommended
Improving Apache Spark Downscaling
Improving Apache Spark DownscalingDatabricks
?
The document discusses Google's Cloud Dataproc, a fully-managed service for Apache Spark and Hadoop, detailing its integration with various Google Cloud products and the management of cluster resources through autoscaling. It addresses the complexities and challenges of optimizing Spark jobs, particularly focusing on shuffle processing, data management, and the transition to Kubernetes for enhanced control and performance. Additionally, it highlights advancements in external shuffling mechanisms to improve efficiency and reduce the impact of scaling operations.Database Management systems - Data Independence
Database Management systems - Data IndependenceDEEPIKAP92
?
Data independence refers to the ability to modify a database's schema at one level without affecting higher levels and allows changes to the conceptual and physical schemas without altering the external schema. There are two types: logical data independence, which means changing the conceptual schema does not require changing the external schema visible to users, and physical data independence, which is the ability to change the internal physical storage without requiring changes to the conceptual schema.Zero Downtime Schema Changes - Galera Cluster - Best Practices
Zero Downtime Schema Changes - Galera Cluster - Best PracticesSeveralnines
?
The document discusses schema upgrades in Galera clusters focusing on methods for online DDL operations while maintaining system availability. Key techniques include Total Order Isolation (TOI) for strict consistency, Rolling Schema Upgrades (RSU), and the use of the pt-online-schema-change tool for non-blocking schema changes. Emphasis is placed on ensuring backward compatibility for applications and row replication during upgrades.PTC Live: Integrating PTC Windchill with Cadence PCB Design
PTC Live: Integrating PTC Windchill with Cadence PCB DesignEMA Design Automation
?
The document discusses integrating PTC Windchill with Cadence PCB design data to create a single source of truth for electronic product creation. This would consolidate disconnected data sources, decrease time to market, and improve quality and compliance by centralizing ECAD libraries, automating data storage and retrieval, and enabling traceability at the component level. The integration would provide benefits such as a centralized library and product configuration database, integration of component compliance and lifecycle information, and an automated new part introduction process.Your Data, Your Search, ElasticSearch (EURUKO 2011)
Your Data, Your Search, ElasticSearch (EURUKO 2011)Karel Minarik
?
The document discusses search implementation and ElasticSearch. It begins with an overview of how search works by indexing documents into an inverted index of tokens and associated document postings. It then provides a Ruby implementation of a basic search index and demonstrates indexing documents and searching the index. The document concludes by describing features of ElasticSearch like its use of HTTP and JSON, schema-free indexing, distributed search capabilities, and Ruby integration.Scaling your analytics with Amazon EMR
Scaling your analytics with Amazon EMRIsrael AWS User Group
?
The document discusses using Amazon EMR to scale analytics workloads on AWS. It provides an overview of EMR and how it allows users to easily run Hadoop clusters on AWS. It discusses how EMR allows tuning clusters and reducing costs by using Spot instances. It also discusses using various AWS services like S3, HDFS and integrating various Hadoop ecosystem tools on EMR. It provides examples of using EMR for batch processing logs, as a long-running database and for ad-hoc analysis of large datasets. It emphasizes using S3 for persistent storage and provides best practices around file sizes, compression and bootstrap actions.ORACLE ARCHITECTURE
ORACLE ARCHITECTUREManohar Tatwawadi
?
The document provides an overview of Oracle architecture including:
- Data is stored in data blocks which make up extents that form segments within tablespaces. Segments represent database objects like tables and indexes.
- The system global area (SGA) resides in memory and caches data and structures for efficient processing. It includes the database buffer cache, redo log buffer, and shared pool.
- Server processes handle SQL statements by parsing, executing, and returning results. Background processes perform functions like checkpoint, recovery, and writing data to disk.
- Transactions are written to the redo log and undo segments maintain rollback information. This supports data consistency, recovery, and rolling back transactions.Postgresql Up And Running Regina Obe Leo Hsu
Postgresql Up And Running Regina Obe Leo Hsuzahidtraaslw
?
Postgresql Up And Running Regina Obe Leo Hsu
Postgresql Up And Running Regina Obe Leo Hsu
Postgresql Up And Running Regina Obe Leo HsuGSoC2014 - PGDay Ijui/RS Presentation October, 2016
GSoC2014 - PGDay Ijui/RS Presentation October, 2016 Fabrzio Mello
?
Fabrizio Mello is a PostgreSQL consultant and contributor. He discusses his background and involvement with PostgreSQL including contributing over 35 patches as a developer and reviewer. He describes PostgreSQL as the world's most advanced open source database and provides a brief history. Mello also discusses his 2011 Google Summer of Code project to implement ALTER TABLE to change tables between logged and unlogged status in PostgreSQL.9.6_Course Material-Postgresql_002.pdf
9.6_Course Material-Postgresql_002.pdfsreedb2
?
This document outlines an advanced administration training course for PostgreSQL. The agenda covers topics such as installation, configuration, database management, security, backups and recovery, performance tuning, replication, and monitoring. It introduces PostgreSQL and its features, community support resources, architecture including processes, memory, and disk structures, and provides objectives for individual training modules.Learning postgresql
Learning postgresqlDAVID RAUDALES
?
The document is a comprehensive guide on PostgreSQL, covering installation, data access, aggregate functions, backup and restore processes, and various programming and query techniques across multiple chapters. It provides examples for both beginners and advanced users, detailing how to install PostgreSQL on different operating systems and work with various data types, functions, and high availability setups. Additionally, it outlines usage tips, troubleshooting, and references to external resources for further learning.Postgresql quick guide
Postgresql quick guideAshoka Vanjare
?
PostgreSQL is an open-source relational database management system that runs on Linux, Unix, Windows and Mac OS. It supports SQL queries, transactions, foreign keys, triggers and views. To install PostgreSQL, download the installer package for your platform and run through the installation process, which sets up the database files and creates a default database and user account. The psql command-line tool can then be used to interact with and administer the PostgreSQL database using SQL commands.Getting started with postgresql
Getting started with postgresqlbotsplash.com
?
This document provides an overview of Postgresql, including its history, capabilities, advantages over other databases, best practices, and references for further learning. Postgresql is an open source relational database management system that has been in development for over 30 years. It offers rich SQL support, high performance, ACID transactions, and extensive extensibility through features like JSON, XML, and programming languages.Object Relational Database Management System
Object Relational Database Management SystemAmar Myana
?
PostgreSQL is an object-relational database management system (ORDBMS) that is cross-platform and implements the majority of the SQL:2011 standard. It uses a client-server model with a postmaster daemon process that manages connections to backend server processes. PostgreSQL supports features like ACID compliance, transactions, complex queries, user-defined objects, and built-in replication. It allows custom indexing and inheritance between tables. To get started, users can create databases and tables, populate them with data, and perform queries.GSoC2014 - Uniritter Presentation May, 2015
GSoC2014 - Uniritter Presentation May, 2015Fabrzio Mello
?
The document discusses databases, particularly focusing on PostgreSQL, including its features, history, and contributions by Fabrzio de Royes Mello, who has extensive experience and is a consultant and contributor to PostgreSQL. It explains the concept of unlogged tables introduced in PostgreSQL 9.1, highlighting their speed advantages and caveats, such as lack of crash safety and replication. The document also provides insights into the mechanics of altering table persistence and acknowledges contributions from various individuals in the PostgreSQL community.PostgreSQL- An Introduction
PostgreSQL- An IntroductionSmita Prasad
?
This document provides an introduction and overview of PostgreSQL, an open-source object-relational database management system. It discusses that PostgreSQL supports modern SQL features, has free commercial and academic use, and offers performance comparable to other databases while being very reliable with stable code and robust testing. The architecture uses a client-server model to handle concurrent connections and transactions provide atomic, isolated, and durable operations. PostgreSQL also supports user-defined types, inheritance, and other advanced features.Chjkkkkkkkkkkkkkkkkkjjjjjjjjjjjjjjjjjjjjjjjjjj01_The Basics.pptx
Chjkkkkkkkkkkkkkkkkkjjjjjjjjjjjjjjjjjjjjjjjjjj01_The Basics.pptxMhmdMk10
?
The document provides an overview of relational database management systems (RDBMS), focusing on their architecture, advantages over traditional file systems, and data structuring concepts such as schema and data manipulation languages. It highlights PostgreSQL as a leading open-source RDBMS, detailing its features, administration tools, and database objects including tables, views, and triggers. Additionally, it discusses the importance of database drivers for various programming languages to facilitate interactions with PostgreSQL.Bn 1016 demo postgre sql-online-training
Bn 1016 demo postgre sql-online-trainingconline training
?
The document provides an introduction to PostgreSQL for developers, covering essential topics such as installation, database management, and SQL functions. It emphasizes PostgreSQLs features including extensibility, security, and reliability, as well as its architectural processes. The course aims to equip participants with fundamental knowledge of PostgreSQL through practical demonstrations and a structured agenda.Postgresql tutorial
Postgresql tutorialAshoka Vanjare
?
PostgreSQL is an open source relational database management system. It has over 15 years of active development and supports most operating systems. The tutorial provides instructions on installing PostgreSQL on Linux, Windows, and Mac operating systems. It also gives an overview of PostgreSQL's features and procedural language support.0292-introduction-postgresql.pdf
0292-introduction-postgresql.pdfMustafa Keskin
?
PostgreSQL is an open source object-relational database management system. The document provides an introduction and overview of PostgreSQL, including its features, interfaces, data types, functions, operators, and more. It also covers installation, configuration, usage and maintenance of PostgreSQL databases.Introduction to PostgreSQL for System Administrators
Introduction to PostgreSQL for System AdministratorsJignesh Shah
?
This document provides an introduction and overview of PostgreSQL for system administrators. It covers why to use open source databases like PostgreSQL, a quick start guide to installing and configuring PostgreSQL, PostgreSQL internals like file system layout and processes, and monitoring PostgreSQL performance using tools like iostat and top. The presentation is aimed at helping system administrators get started with managing PostgreSQL databases.OpenGurukul : Database : PostgreSQL
OpenGurukul : Database : PostgreSQLOpen Gurukul
?
This document provides an overview of PostgreSQL and instructions for installing and configuring it. It discusses using the initdb command to initialize a PostgreSQL database cluster and create the template1 and postgres databases. It also explains that the template1 database serves as a template that is copied whenever new databases are created.Postgresql
PostgresqlNexThoughts Technologies
?
PostgreSQL, an advanced open-source object-relational database, originated in 1986 and has evolved significantly through various versions, introducing numerous features like user-defined types and efficient concurrency handling through multi-version concurrency control (MVCC). Compared to MySQL, PostgreSQL offers extensive support for complex data types, JSON, and geospatial data, alongside superior compliance with SQL standards and enhanced security features. The document also details fundamental operations, permissions management, and the creation and manipulation of databases and tables in PostgreSQL.Getting by with just psql
Getting by with just psqlCorey Huinker
?
This document discusses using only the psql command line tool to interact with PostgreSQL databases. It describes how psql can be used for tasks like logging, auditing, and sanitizing input through the use of variables and temporary tables. Various psql commands are covered, including slash commands, the \set command for setting variables, and the \gset and \gexec commands for capturing and executing SQL statements. The document also discusses how conditionals can be implemented in psql prior to version 10 and improvements added in version 10 with commands like \if.PostgreSQL - Case Study
PostgreSQL - Case StudyS.Shayan Daneshvar
?
PostgreSQL is an open-source object-relational database management system descended from POSTGRES. It supports many SQL standards and features extensions like user-defined data types, functions, operators and index methods. Transactions in PostgreSQL provide ACID properties including atomicity, consistency, isolation and durability to maintain data integrity during concurrent operations.An evening with Postgresql
An evening with PostgresqlJoshua Drake
?
The document presents insights on PostgreSQL, an advanced open-source database highlighting its features, community structure, and comparisons with other databases. It discusses PostgreSQL's support for JSON and logical decoding, along with enhancements in version 9.4, such as multi-master replication and improved indexing. The presentation is meant to educate and foster appreciation for PostgreSQL among its audience.Postgresql v15.1
Postgresql v15.1Banking at Ho Chi Minh city
?
This document provides the table of contents and introduction for the PostgreSQL 15.1 documentation. It describes that PostgreSQL is an open-source object-relational database system that uses and extends the SQL language combined with many features that safely store and scale the most complicated data workloads. The documentation is copyrighted by the PostgreSQL Global Development Group and provides instructions for how to report bugs and get further information.Py spark cheat sheet by cheatsheetmaker.com
Py spark cheat sheet by cheatsheetmaker.comLam Hoang
?
The document is a cheat sheet for PySpark, an interface for Apache Spark in Python, detailing how to initialize SparkContext, load and manipulate data using RDDs, and perform various operations such as counting, filtering, and aggregating data. It includes examples of commands for creating RDDs, retrieving information, applying functions, reshaping data, and performing mathematical operations. The cheat sheet serves as a quick reference for users working with PySpark.VS Code cheat sheet
VS Code cheat sheetLam Hoang
?
This document is a cheat sheet for Visual Studio Code that lists keyboard shortcuts for general commands, search and replace, multi-cursor and selection, file management, display, debugging, the integrated terminal, navigation, editing, and commenting. It provides over 100 shortcuts to help users quickly access common commands in Visual Studio Code without using a mouse.More Related Content
Similar to PostgreSql cheat sheet (20)
Postgresql Up And Running Regina Obe Leo Hsu
Postgresql Up And Running Regina Obe Leo Hsuzahidtraaslw
?
Postgresql Up And Running Regina Obe Leo Hsu
Postgresql Up And Running Regina Obe Leo Hsu
Postgresql Up And Running Regina Obe Leo HsuGSoC2014 - PGDay Ijui/RS Presentation October, 2016
GSoC2014 - PGDay Ijui/RS Presentation October, 2016 Fabrzio Mello
?
Fabrizio Mello is a PostgreSQL consultant and contributor. He discusses his background and involvement with PostgreSQL including contributing over 35 patches as a developer and reviewer. He describes PostgreSQL as the world's most advanced open source database and provides a brief history. Mello also discusses his 2011 Google Summer of Code project to implement ALTER TABLE to change tables between logged and unlogged status in PostgreSQL.9.6_Course Material-Postgresql_002.pdf
9.6_Course Material-Postgresql_002.pdfsreedb2
?
This document outlines an advanced administration training course for PostgreSQL. The agenda covers topics such as installation, configuration, database management, security, backups and recovery, performance tuning, replication, and monitoring. It introduces PostgreSQL and its features, community support resources, architecture including processes, memory, and disk structures, and provides objectives for individual training modules.Learning postgresql
Learning postgresqlDAVID RAUDALES
?
The document is a comprehensive guide on PostgreSQL, covering installation, data access, aggregate functions, backup and restore processes, and various programming and query techniques across multiple chapters. It provides examples for both beginners and advanced users, detailing how to install PostgreSQL on different operating systems and work with various data types, functions, and high availability setups. Additionally, it outlines usage tips, troubleshooting, and references to external resources for further learning.Postgresql quick guide
Postgresql quick guideAshoka Vanjare
?
PostgreSQL is an open-source relational database management system that runs on Linux, Unix, Windows and Mac OS. It supports SQL queries, transactions, foreign keys, triggers and views. To install PostgreSQL, download the installer package for your platform and run through the installation process, which sets up the database files and creates a default database and user account. The psql command-line tool can then be used to interact with and administer the PostgreSQL database using SQL commands.Getting started with postgresql
Getting started with postgresqlbotsplash.com
?
This document provides an overview of Postgresql, including its history, capabilities, advantages over other databases, best practices, and references for further learning. Postgresql is an open source relational database management system that has been in development for over 30 years. It offers rich SQL support, high performance, ACID transactions, and extensive extensibility through features like JSON, XML, and programming languages.Object Relational Database Management System
Object Relational Database Management SystemAmar Myana
?
PostgreSQL is an object-relational database management system (ORDBMS) that is cross-platform and implements the majority of the SQL:2011 standard. It uses a client-server model with a postmaster daemon process that manages connections to backend server processes. PostgreSQL supports features like ACID compliance, transactions, complex queries, user-defined objects, and built-in replication. It allows custom indexing and inheritance between tables. To get started, users can create databases and tables, populate them with data, and perform queries.GSoC2014 - Uniritter Presentation May, 2015
GSoC2014 - Uniritter Presentation May, 2015Fabrzio Mello
?
The document discusses databases, particularly focusing on PostgreSQL, including its features, history, and contributions by Fabrzio de Royes Mello, who has extensive experience and is a consultant and contributor to PostgreSQL. It explains the concept of unlogged tables introduced in PostgreSQL 9.1, highlighting their speed advantages and caveats, such as lack of crash safety and replication. The document also provides insights into the mechanics of altering table persistence and acknowledges contributions from various individuals in the PostgreSQL community.PostgreSQL- An Introduction
PostgreSQL- An IntroductionSmita Prasad
?
This document provides an introduction and overview of PostgreSQL, an open-source object-relational database management system. It discusses that PostgreSQL supports modern SQL features, has free commercial and academic use, and offers performance comparable to other databases while being very reliable with stable code and robust testing. The architecture uses a client-server model to handle concurrent connections and transactions provide atomic, isolated, and durable operations. PostgreSQL also supports user-defined types, inheritance, and other advanced features.Chjkkkkkkkkkkkkkkkkkjjjjjjjjjjjjjjjjjjjjjjjjjj01_The Basics.pptx
Chjkkkkkkkkkkkkkkkkkjjjjjjjjjjjjjjjjjjjjjjjjjj01_The Basics.pptxMhmdMk10
?
The document provides an overview of relational database management systems (RDBMS), focusing on their architecture, advantages over traditional file systems, and data structuring concepts such as schema and data manipulation languages. It highlights PostgreSQL as a leading open-source RDBMS, detailing its features, administration tools, and database objects including tables, views, and triggers. Additionally, it discusses the importance of database drivers for various programming languages to facilitate interactions with PostgreSQL.Bn 1016 demo postgre sql-online-training
Bn 1016 demo postgre sql-online-trainingconline training
?
The document provides an introduction to PostgreSQL for developers, covering essential topics such as installation, database management, and SQL functions. It emphasizes PostgreSQLs features including extensibility, security, and reliability, as well as its architectural processes. The course aims to equip participants with fundamental knowledge of PostgreSQL through practical demonstrations and a structured agenda.Postgresql tutorial
Postgresql tutorialAshoka Vanjare
?
PostgreSQL is an open source relational database management system. It has over 15 years of active development and supports most operating systems. The tutorial provides instructions on installing PostgreSQL on Linux, Windows, and Mac operating systems. It also gives an overview of PostgreSQL's features and procedural language support.0292-introduction-postgresql.pdf
0292-introduction-postgresql.pdfMustafa Keskin
?
PostgreSQL is an open source object-relational database management system. The document provides an introduction and overview of PostgreSQL, including its features, interfaces, data types, functions, operators, and more. It also covers installation, configuration, usage and maintenance of PostgreSQL databases.Introduction to PostgreSQL for System Administrators
Introduction to PostgreSQL for System AdministratorsJignesh Shah
?
This document provides an introduction and overview of PostgreSQL for system administrators. It covers why to use open source databases like PostgreSQL, a quick start guide to installing and configuring PostgreSQL, PostgreSQL internals like file system layout and processes, and monitoring PostgreSQL performance using tools like iostat and top. The presentation is aimed at helping system administrators get started with managing PostgreSQL databases.OpenGurukul : Database : PostgreSQL
OpenGurukul : Database : PostgreSQLOpen Gurukul
?
This document provides an overview of PostgreSQL and instructions for installing and configuring it. It discusses using the initdb command to initialize a PostgreSQL database cluster and create the template1 and postgres databases. It also explains that the template1 database serves as a template that is copied whenever new databases are created.Postgresql
PostgresqlNexThoughts Technologies
?
PostgreSQL, an advanced open-source object-relational database, originated in 1986 and has evolved significantly through various versions, introducing numerous features like user-defined types and efficient concurrency handling through multi-version concurrency control (MVCC). Compared to MySQL, PostgreSQL offers extensive support for complex data types, JSON, and geospatial data, alongside superior compliance with SQL standards and enhanced security features. The document also details fundamental operations, permissions management, and the creation and manipulation of databases and tables in PostgreSQL.Getting by with just psql
Getting by with just psqlCorey Huinker
?
This document discusses using only the psql command line tool to interact with PostgreSQL databases. It describes how psql can be used for tasks like logging, auditing, and sanitizing input through the use of variables and temporary tables. Various psql commands are covered, including slash commands, the \set command for setting variables, and the \gset and \gexec commands for capturing and executing SQL statements. The document also discusses how conditionals can be implemented in psql prior to version 10 and improvements added in version 10 with commands like \if.PostgreSQL - Case Study
PostgreSQL - Case StudyS.Shayan Daneshvar
?
PostgreSQL is an open-source object-relational database management system descended from POSTGRES. It supports many SQL standards and features extensions like user-defined data types, functions, operators and index methods. Transactions in PostgreSQL provide ACID properties including atomicity, consistency, isolation and durability to maintain data integrity during concurrent operations.An evening with Postgresql
An evening with PostgresqlJoshua Drake
?
The document presents insights on PostgreSQL, an advanced open-source database highlighting its features, community structure, and comparisons with other databases. It discusses PostgreSQL's support for JSON and logical decoding, along with enhancements in version 9.4, such as multi-master replication and improved indexing. The presentation is meant to educate and foster appreciation for PostgreSQL among its audience.Postgresql v15.1
Postgresql v15.1Banking at Ho Chi Minh city
?
This document provides the table of contents and introduction for the PostgreSQL 15.1 documentation. It describes that PostgreSQL is an open-source object-relational database system that uses and extends the SQL language combined with many features that safely store and scale the most complicated data workloads. The documentation is copyrighted by the PostgreSQL Global Development Group and provides instructions for how to report bugs and get further information.More from Lam Hoang (14)
Py spark cheat sheet by cheatsheetmaker.com
Py spark cheat sheet by cheatsheetmaker.comLam Hoang
?
The document is a cheat sheet for PySpark, an interface for Apache Spark in Python, detailing how to initialize SparkContext, load and manipulate data using RDDs, and perform various operations such as counting, filtering, and aggregating data. It includes examples of commands for creating RDDs, retrieving information, applying functions, reshaping data, and performing mathematical operations. The cheat sheet serves as a quick reference for users working with PySpark.VS Code cheat sheet
VS Code cheat sheetLam Hoang
?
This document is a cheat sheet for Visual Studio Code that lists keyboard shortcuts for general commands, search and replace, multi-cursor and selection, file management, display, debugging, the integrated terminal, navigation, editing, and commenting. It provides over 100 shortcuts to help users quickly access common commands in Visual Studio Code without using a mouse.Nginx cheat sheet
Nginx cheat sheetLam Hoang
?
This document provides a cheat sheet on how to configure the Nginx web server for common use cases such as setting ports and domain names, serving static files, redirects, reverse proxying, TLS/SSL encryption, load balancing, and access logging. It includes configuration examples for listening on ports, setting server names, serving static assets, 301 and 302 redirects, basic and upgraded reverse proxying, HTTPS setup, and load balancing multiple servers.MySql cheat sheet
MySql cheat sheetLam Hoang
?
This document provides a summary of tools and commands for monitoring, administering and optimizing a MySQL database. It describes utilities like mytop and innotop for live monitoring of MySQL, commands for checking status, lists of databases/tables/columns, and how to view and change configuration parameters. Methods for remote data dumps/imports, importing CSV files, and handling query output are also outlined.Html cheat sheet
Html cheat sheetLam Hoang
?
The document provides a cheat sheet of basic HTML tags for formatting text, creating lists, adding images and links, and other common elements in an HTML document. It includes opening and closing tags for paragraphs, headings, bold, italic, and other text styling, as well as tags for lists, images, horizontal rules, and hyperlinks.Git cheat sheet
Git cheat sheetLam Hoang
?
Git is a version control system for tracking changes to source code. The document provides instructions for configuring Git, creating repositories, ignoring files, working with branches, synchronizing changes, making changes to code, undoing commits, and definitions for key Git terms like commit, branch, clone, remote, fork, pull request and HEAD.Django cheat sheet
Django cheat sheetLam Hoang
?
This document summarizes key aspects of using the Django web framework:
1) It describes how to start a new Django project, create apps, define models, migrate the database, and run the development server.
2) It explains how to build templates, map URLs, write views, and use templates to display data on pages.
3) It covers template inheritance, using parameters from URLs in views, and accessing context data from views in templates.Css cheat sheet
Css cheat sheetLam Hoang
?
Cascading Style Sheets (CSS) is a style sheet language used for describing the presentation of HTML documents. CSS cheat sheets provide a reference for useful CSS properties, selectors, and other elements. The document includes sections summarizing CSS properties for text styling, positioning, backgrounds, boxes, lists, flexbox, grid, dynamic content and more.Apache cheat sheet
Apache cheat sheetLam Hoang
?
The Apache HTTP Server, commonly called Apache, is a free and open-source cross-platform web server software released under the terms of the Apache License 2.0. The document provides a cheat sheet of useful commands and configurations for Apache including listing virtual hosts and modules, rewriting URLs, authentication, log rotation, data privacy, and security mitigations.Battle chatter minecraft 1.4.7 mod
Battle chatter minecraft 1.4.7 modLam Hoang
?
The BattleChatterMinecraft 1.4.7 Mod allows players to organize groups with features like an allies list to identify friends, built-in IRC chat across servers, customizable clan tags and nameplates, and options to share health information and prevent friendly fire over long distances to help coordinate in battles. The mod installer instructions say to download and install Modloader, delete the META-INF file, drag the mod files into the Minecraft.jar, and run the game.On thi dai_hoc_mon_van_2010 (1)
On thi dai_hoc_mon_van_2010 (1)Lam Hoang
?
Ti li?u khm ph v? Nguy?n Ai Qu?c v H? Ch Minh, t?p trung vo s? nghi?p, phong cch s?ng v nh?ng ?nh h??ng c?a h? trong v?n h?c Vi?t Nam tr??c v sau n?m 1945. Hai nh?n v?t ny th? hi?n nh?ng giai ?o?n khc nhau trong cu?c s?ng c?a ??t n??c, t? th?i k? khng chi?n ??n x?y d?ng ??t n??c. Ti li?u c?ng nh?n m?nh t?m quan tr?ng c?a cc tc ph?m v?n h?c v s? k?t n?i v?i l?ch s? v v?n ha Vi?t Nam.?n thi m?n v?n
?n thi m?n v?nLam Hoang
?
Ti li?u ph?n tch v? c?m gic bu?n b? trong th? ca nh?ng n?m 1930-1945, ??c bi?t trong ch? ?? ma thu v xu?n v?i nh?ng t?m tr?ng l?c l?ng v n?i c? ??n. Th? ca th??ng g?n li?n v?i thin nhin, th? hi?n n?i bu?n v s? chia ly qua hnh ?nh ma thu, dng s?ng v c?nh v?t xung quanh. Cc tc ph?m th? hi?n c?m xc s?u s?c c?a con ng??i tr??c nh?ng khung c?nh thin nhin c?ng nh? l t?m tr?ng c?a chnh mnh.On thi dai_hoc_mon_van_2010
On thi dai_hoc_mon_van_2010Lam Hoang
?
Ti li?u ph?n tch v? hai tc gi? l?n, Nguyn Ai Quc v H? Ch Minh, nh?ng ?ng gp c?a h? ??i v?i v?n h?c Vi?t Nam tr??c v sau cch m?ng thng Tm 1945. ??c bi?t, n lm r? hai phong cch sng tc khc nhau c?a h? v t?m ?nh h??ng ??n n?n v?n ha, t? t??ng cch m?ng. S? khc bi?t gi?a hai tc gi? c?ng ph?n nh nh?ng ?i?u ki?n l?ch s? v x? h?i trong th?i k? h? ho?t ??ng.gio trnh c c?n b?n
gio trnh c c?n b?nLam Hoang
?
Gio trnh l?p trnh C c?n b?n cung c?p ki?n th?c v? ng?n ng? l?p trnh, ph??ng php l?p trnh v cc b??c l?p trnh. N bao g?m t? khi ni?m thu?t ton, ch??ng trnh, ??n cc thnh ph?n ng?n ng? C v cch th?c nh?p/xu?t d? li?u. Ngoi ra, ti li?u cn h??ng d?n v? c?u trc ?i?u ki?n, vng l?p, hm, m?ng, con tr? v cc ki?u d? li?u t? t?o.Ad
Recently uploaded (20)
Complete guidance book of Asp.Net Web API
Complete guidance book of Asp.Net Web APIShabista Imam
?
Unlock the full potential of modern web development with the Complete Guidance Book of ASP.NET Web APIyour all-in-one resource for mastering RESTful services using Microsofts powerful ASP.NET Core framework. This book takes you on a step-by-step journey from beginner to expert, covering everything from routing and controllers to security, performance optimization, and real-world architecture.How to Un-Obsolete Your Legacy Keypad Design
How to Un-Obsolete Your Legacy Keypad DesignEpec Engineered Technologies
?
For any number of circumstances, obsolescence risk is ever present in the electronics industry. This is especially true for human-to-machine interface hardware, such as keypads, touchscreens, front panels, bezels, etc. This industry is known for its high mix and low-volume builds, critical design requirements, and high costs to requalify hardware. Because of these reasons, many programs will face end-of-life challenges both at the component level as well as at the supplier level.
Redesigns and qualifications can take months or even years, so proactively managing this risk is the best way to deter this. If an LED is obsolete or a switch vendor has gone out of business, there are options to proceed.
In this webinar, we cover options to redesign and reverse engineer legacy keypad and touchscreen designs.
For more information on our HMI solutions, visit https://www.epectec.com/user-interfaces.
Rapid Prototyping for XR: Lecture 3 - Video and Paper Prototyping
Rapid Prototyping for XR: Lecture 3 - Video and Paper PrototypingMark Billinghurst
?
This is lecture 3 in the course on Rapid Prototyping for XR, taught by Mark Billinghurst on June 10th 2025. This lecture is about Video and Paper prototyping.????? ?? ??????? ?????????? ????? ?????? ??? ????.pdf
????? ?? ??????? ?????????? ????? ?????? ??? ????.pdf???? ??? ?????
?
????? ?? ??????? ?????????? ????? ?????? ??? ???? ????? ????? Data Structures Module 3 Binary Trees Binary Search Trees Tree Traversals AVL...
Data Structures Module 3 Binary Trees Binary Search Trees Tree Traversals AVL...resming1
?
This covers binary trees, binary search trees, BST insertion, deletion, tree traversals - inorder, preorder, postorder, AVL trees, AVL tree insertion, deletion, BTrees - insertion, deletion, hash tables etc.Deep Learning for Natural Language Processing_FDP on 16 June 2025 MITS.pptx
Deep Learning for Natural Language Processing_FDP on 16 June 2025 MITS.pptxresming1
?
This gives an introduction to how NLP has evolved from the time of World War II till this date through the advances in approaches, architectures and word representations. From rule based approaches, it advanced to statistical approaches. from traditional machine learning algorithms it advanced to deep neural network architectures. Deep neural architectures include recurrent neural networks, long short term memory, gated recurrent units, seq2seq models, encoder decoder models, transformer architecture, upto large language models and vision language models which are multimodal in nature.Modern multi-proposer consensus implementations
Modern multi-proposer consensus implementationsFran?ois Garillot
?
Multi-proposer consensus protocols let multiple validators propose blocks in parallel, breaking the single-leader throughput bottleneck of classic designs. Yet the modern multi-proposer consensus implementation has grown a lot since HotStuff. THisworkshop will explore the implementation details of recent advances C DAG-based approaches like Narwhal and Suis Mysticeti C and reveal how implementation details translate to real-world performance gains. We focus on the nitty-gritty: how network communication patterns and data handling affect throughput and latency. New techniques such as Turbine-like block propagation (inspired by Solanas erasure-coded broadcast) and lazy push gossip broadcasting dramatically cut communication overhead. These optimizations arent just theoretical C they enable modern blockchains to process over 100,000 transactions per second with finality in mere milliseconds? redefining what is possible in decentralized systems.
Generative AI & Scientific Research : Catalyst for Innovation, Ethics & Impact
Generative AI & Scientific Research : Catalyst for Innovation, Ethics & ImpactAlqualsaDIResearchGr
?
Invited keynote at the Artificial Intelligence Symposium on AI-powered Research Innovation, taking place at ENSEM (L'?cole Nationale Suprieure d'?lectricit et de Mcanique), Casablanca on June 21, 2025. Ill be giving a keynote titled: "Generative AI & Scientific Research: Catalyst for Innovation, Ethics & Impact". Looking forward to engaging with researchers and doctoral students on how Generative AI is reshaping the future of science, from discovery to governance with both opportunities and responsibilities in focus.
#AI hashtag#GenerativeAI #ScientificResearch #Innovation #Ethics #Keynote #AIinScience #GAI #ResearchInnovation #Casablanca
1. Thinking, Creative Thinking, Innovation
2. Societies Evolution from 1.0 to 5.0
3. AI - 3P Approach, Use Cases & Innovation
4. GAI & Creativity
5. TrustWorthy AI
6. Guidelines on The Responsible use of GAI In Research݆iY_Miipher and Miipher2 .
݆iY_Miipher and Miipher2 .ʽ
?
YϤǤϡGoogle DeepMindԪǥ롸Miipher / Miipher-2B餷ƤޤMiipher-2USM + WaveFitɤˤꡢƥȲҪلIgF100TPU100rg3դDŽI륹`ӥƥ؏դǤ
It introduces Miipher / Miipher-2, Google DeepMind's speech enhancement and restoration models.
Miipher-2 uses a USM + WaveFit setup for text-free and efficient processing, and it scales to clean 1M hours of audio in 3 days on 100 TPUs.FUNDAMENTALS OF COMPUTER ORGANIZATION AND ARCHITECTURE
FUNDAMENTALS OF COMPUTER ORGANIZATION AND ARCHITECTUREShabista Imam
?
FUNDAMENTALS OF COMPUTER ORGANIZATION AND ARCHITECTURE
By : Mostafa Abd-El-Barr & Hesham El-Rewini:: wiley
A complete guidance bookStability of IBR Dominated Grids - IEEE PEDG 2025 - short.pptx
Stability of IBR Dominated Grids - IEEE PEDG 2025 - short.pptxssuser307730
?
ݺߣs from IEEE PEDG 2025 Conference in Nanajing. Addresses need for re-examining grid stability when using large numbers of inverter-based resources.Introduction to Python Programming Language
Introduction to Python Programming Languagemerlinjohnsy
?
This PPT covers features, applications, variable, data types and statements in PythonAd
PostgreSql cheat sheet
- 1. PostgreSqlCheatSheet PostgreSQLalsoknownasPostgres,isafreeandopen-sourcerelationaldatabase managementsystem(RDBMS)emphasizingextensibilityandSQLcompliance. bylam ?PSQL Login psql -U postgres Someinterestingflags(tosee all,use-hor--help dependingonyourpsql version): -E:willdescribethe underlayingqueriesofthe commands(coolfor learning!) -l:psqlwilllistall databasesandthenexit (usefuliftheuseryou connectwithdoesn'thas adefaultdatabase,likeat AWSRDS) Mostdcommandssupport additionalparamof __schema__.name__and acceptwildcardslike*.* q:Quit/Exit c__database__:Connect toadatabase d__table__:Showtable definition(columns,etc.) includingtriggers d+__table__:More detailedtabledefinition includingdescriptionand physicaldisksize l:Listdatabases dy:Listevents df:Listfunctions di:Listindexes dn:Listschemas ?Configuration Servicemanagement commands: sudo service postgresq l stop sudo service postgresq l start sudo service postgresq l restart Changingverbosity& queryingPostgreslog: Firstedittheconfigfile,seta decentverbosity,saveand restartpostgres: sudo vim /etc/postgresq l/9.3/main/postgresql.c onf # Uncomment/Change insi de: log_min_messages = debu g5 log_min_error_statemen t = debug5 log_min_duration_statem ent = -1 sudo service postgresq l restart Nowyouwillgettonsof detailsofeverystatement, error,andevenbackground taskslikeVACUUMs tail -f /var/log/postgr esql/postgresql-9.3-mai n.log Howtoadduserwho executedaPGstatementto log(editingpostgresql.conf): log_line_prefix = '%t % ?Createcommand TherearemanyCREATE choices,likeCREATE DATABASE __database_name__,CREATE TABLE__table_name__... Parametersdifferbutcanbe checkedattheofficial documentation. ?Handyqueries Listprocedure/function SELECT * FROM pg_proc W HERE proname='__procedu rename__' Listview(includingthe definition) SELECT * FROM pg_views WHERE viewname='__viewn ame__'; ShowDBtablespaceinuse SELECT pg_size_pretty(p g_total_relation_size ('__table_name__')); ShowDBspaceinuse SELECT pg_size_pretty(p g_database_size('__data base_name__')); Showcurrentuser's statementtimeout show statement_timeout; Showtableindexes SELECT * FROM pg_indexe ? ?
- 2. dt .:Listtablesfromall schemas(if*.*isomitted willonlyshow SEARCH_PATHones) dT+:Listalldatatypes dv:Listviews dx:Listallextensions installed df+__function__:Show functionSQLcode. x:Pretty-formatquery resultsinsteadofthenot- so-usefulASCIItables copy(SELECT*FROM __table_name__)TO 'file_path_and_name.csv' WITHCSV:Exportatable asCSV des+:Listallforeign servers dE[S+]:Listallforeign tables UserRelated: du:Listusers du__username__:Lista usernameifpresent. createrole__test1__: Createarolewithan existingusername. createrole__test2__ noinheritloginpassword __passsword__;:Createa rolewithusernameand password. setrole__test__;:Change roleforcurrentsessionto __test__. grant__test2__to __test1__;:Allow__test1__ tosetitsroleas__test2__. deu+:Listalluser mappingonserver u %d %a ' s WHERE tablename='__ta ble_name__' AND scheman ame='__schema_name__'; Getallindexesfromalltables ofaschema: SELECT t.relname AS table_n ame, i.relname AS index_n ame, a.attname AS column_ name FROM pg_class t, pg_class i, pg_index ix, pg_attribute a, pg_namespace n WHERE t.oid = ix.indrelid AND i.oid = ix.index relid AND a.attrelid = t.o id AND a.attnum = ANY(i x.indkey) AND t.relnamespace = n.oid AND n.nspname = 'ka rtones' ORDER BY t.relname, i.relname Executiondata SELECT datname, applica tion_name, pid, backend _start, query_start, st ate_change, state, quer y FROM pg_stat_activit y WHERE datname='__data base_name__'; Getallqueriesfromalldbs waitingfordata(mightbe hung) SELECT * FROM pg_stat_a ctivity WHERE waiting ='t' Currentlyrunningquerieswith processpid: ? ?
- 3. CheatSheetMaker.com SimpleCheatSheet.com SELECT pg_stat_get_back end_pid(s.backendid) A S procpid, pg_stat_get_backend_ac tivity(s.backendid) AS current_query FROM (SELECT pg_stat_ge t_backend_idset() AS ba ckendid) AS s; Casting CAST(columnAStype) orcolumn::type '__table_name__'::regclass::oid: Getoidhavingatable name Queryanalysis EXPLAIN__query__:see thequeryplanforthe givenquery EXPLAINANALYZE __query__:seeand executethequeryplan forthegivenquery ANALYZE[__table__]: collectstatistics ?Generatingrandomdata INSERT INTO some_table (a_float_value) SELECT random() * 100000 FROM generate_series(1, 1000 000) i; ? ?