Skip to navigation Skip to content
Simon Technology Blog
  • Architecture
  • Cloud
  • Database
  • Develop
  • Hardware
  • Industry
  • Language
  • Mobile
  • Opensource
  • OS
  • Web
Main Navigation

Category: Postgresql

PostgresQL is an object-relational database management system (ORDBMS) based on version 4.2 of POSTGRES developed by the Department of Computer Science at the University of California, Berkeley. It has now been renamed to PostgreSQL. PostgreSQL supports most SQL standards and provides many other modern features: complex queries, foreign keys, triggers, views, transaction integrity, MVCC. Similarly, PostgreSQL can be extended in many ways, for example, by adding new data types, functions, operators, aggregate functions, and indexes. Use, modify, and distribute PostgreSQL for free, whether it is for private, commercial, or academic research.

PostgreSQL11 installation

There are two installation methods for postgresql11: binary source code installation, rpm package installation

wget https: //ftp.postgresql.org/pub/source/v11.5/postgresql-11.5.tar.gz
./confi

September 21, 2021By Simo Postgresql installation, PostgreSQL, postgresql11Leave a Comment

Group of time and space proximity trajectories in R or PostgreSQL

I am using R and PostgreSQL to perform some trajectory analysis. In order to form a group of trajectory segments whose continuous positions are close in time and space, I created the following tabl

September 21, 2021By Simo Postgresql Of the historicsLeave a Comment

Use postgreSQL processing time

I have a table with date and time fields. I have a hard time understanding how I deal with this problem, partly because I don’t understand how time is converted to a number. I use the following The

September 21, 2021By Simo Postgresql PostgreSQL, Processing, time, useLeave a Comment

How do I correctly design a VS matching table in PostgreSQL?

I have considered this problem, and I have not come up with something better. So let me describe my problem, my current solution, and what I want to improve Place. I also have some concerns, such a

September 21, 2021By Simo Postgresql Correction, design, How to, matching, PostgreSQL, table, VSLeave a Comment

PostgreSQL – How do I check the remaining size of persistent disks on Google Cloud? Where can I find the code in the instance?

I created a project on Google Cloud a long time ago and I am currently experiencing some problems. The only result I seem to receive is an internal server error.

I tried to connect to the com

September 21, 2021By Simo Postgresql check, Cloud, Disk, Google, How to, lasting, PostgreSQL, Size, Where, You canLeave a Comment

PostgreSQL, Triple Group and Similarity

Just test PostgreSQL 9.6.2 on my Mac and use Ngrams.
Assuming the brewery has a GIN triplet index.

Similarity limit (I know this is deprecated):

SELECT set_limit(0.5); I am building on

September 21, 2021By Simo Postgresql 3 yuan, Group, PostgreSQL, similarity, ternaryLeave a Comment

Manage users using PostgreSQL

Our system will run on a local network, where no more than 50 clients connect to the same local server. We are creating a DB user for each client to take advantage of postgresql permissions System.

September 21, 2021By Simo Postgresql management, PostgreSQL, use, usersLeave a Comment

PostgreSQL multi-column unique

I have a strange situation in PostgreSQL 9.4.
I have a table:

id integer NOT NULL DEFAULT nextval(‘users_userpropmeta_id_seq’::regclass)
name character varying(255) NOT NULL
cls character va

September 21, 2021By Simo Postgresql inadvertent, multiple columns, PostgreSQL, UniqueLeave a Comment

In PostgreSQL, how to cancel the time zone offset using “At Time Zone”

I’m trying to bypass the Postgresql time zone and I can’t seem to figure this out. EST is “Eastern Standard Time” in the United States, usually UTC-5.

Example 1: Basic test

select ’08/3

September 21, 2021By Simo Postgresql cancel, how to use, in, offset, PostgreSQL, time, time zone, ZoneLeave a Comment

PostgreSQL – Export Heroku Postgres database, but exclude table

I want to export the Postgres database of my Heroku application, but I want to exclude a table. Is this possible?

This is the command I used to export the entire Postgres database:

$PGU

September 21, 2021By Simo Postgresql database, Excluded, export, Heroku, Postgres, PostgreSQL, tableLeave a Comment

Posts navigation

Page 1 … Page 4 Page 5 Page 6 … Page 10
Recent Posts
  • Sencha-Touch-2 – Sencha Touch 2, Nested XML Analysis NodeValue
  • Add a separation line and format XML content
  • Is there a norm of simplified XML subsets?
  • Look at it when you write React
  • ReactJS – Present React Redux React-Router App to add the server to the Firebase hosted by the Firebase
Categories
  • Android
  • Apache
  • Apache Kafka
  • Asp
  • Auto-Test
  • Automated Build
  • Aws
  • Bitcoin
  • Browser
  • C & C++
  • C#
  • Centos
  • Cgi
  • Character
  • Cloud Service
  • Cocos2dx
  • Cordova
  • CSS
  • Data Structure
  • Delphi
  • Design Pattern
  • Dojo
  • Dubbo
  • ELK
  • Flex
  • football
  • Game
  • Hadoop
  • Hibernate
  • HTML
  • Hybrid
  • Intel
  • IOS
  • Ipad
  • iPhone
  • Java
  • Javascript
  • Jetty
  • JQuery
  • Jsp
  • Linux
  • Load Balance
  • Lua
  • Macbook
  • Macos
  • Mathematics
  • Micro Services
  • Monitoring
  • Motherboard
  • Mysql
  • Network Hardware
  • Network Marketing
  • Nginx
  • NodeJs
  • Nosql
  • Oracle
  • Os Theory
  • Performance
  • PHP
  • Postgresql
  • Power Designer
  • React
  • Redis
  • Regexp
  • Rom
  • Rss
  • Ruby
  • Search Engines
  • Shell Script
  • Silicon Valley
  • Silverlight
  • Software Design
  • Spring
  • Sql
  • Sqlite
  • Sqlserver
  • Storage
  • Storm
  • Surface
  • SVN
  • Swift
  • System Architecture
  • Tablet
  • Uncategorized
  • Unix
  • Visual Basic
  • Visual Studio
  • Web Crawler
  • WebService
  • Windows
  • Wireless
  • XML
  • ZooKeeper
Archives
  • October 2021
  • September 2021
  • August 2021
  • May 2021
  • April 2021
  • September 2020
  • September 2019
  • August 2019
  • June 2019
  • May 2019
  • April 2019
  • March 2019
© Simon Technology Blog 2025 • ThemeCountry Powered by WordPress