Updated on 2025-05-29 GMT+08:00
FAQ
- What is the maximum number of columns in a single GaussDB table?
- How do I query the partition and index information of a partitioned table?
- What is OID?
- What is UDF?
- What wildcards are supported in GaussDB? How do I use them?
- Is there a limit on the length of a database object name?
- How do I view the creation time of a table?
- How do I create indexes in parallel?
- How do I create an auto-increment column?
- Can I query the GaussDB memory usage through SQL statements?
- What are the differences between LIMIT 2, LIMIT 2,3 and LIMIT 2 OFFSET 3?
- How do I create a column whose default value is the current time?
- How do I determine whether a column is null?
- How do I obtain the username for connecting to a database?
- How do I query the time difference between two time points?
- What are the types of SQL languages?
- What is the function of a trigger?
- What are the four characteristics of correctly executing database transactions?
- What are the differences between the DROP, TRUNCATE, and DELETE methods in GaussDB?
- How many bytes does a Chinese character occupy in GaussDB?
- How Do I Set the Validity Period of an Account?
- What Are the Differences Between Unique Constraints and Unique Indexes?
- How Do I Create a Weak Password in GaussDB?
- What is Dirty Read, Phantom Read, and Non-repeatable Read?
- What Is MVCC?
- Which Date/Time Types Contain the Time Zone and Which Do Not?
- What Is the Difference Between count(*) and count(column)?
- What Is the Relationship Between an Empty String and NULL?
- What Are WALs and Log File Paths?
- What Are the Schemas, Users, and Roles in GaussDB?
- Does GaussDB Supports Dynamic Memory Management?
- What Is the Schema Starting with pg_temp or pg_toast_temp?
- What Are the Differences Between Functions and Stored Procedures?
- Why Can a User Log In to the Database After the CONNECT ON DATABASE Permission Is Granted to the REVOKE User?
- How Do I Improve the Efficiency when the Entire Table Is Associated with UPDATE?
- How Do I Ignore Case When Using LIKE for Fuzzy Search?
- After the String Processing Function Is Used, the Query Does Not Use the Index. What Should I Do?
- Why Cannot the Table Name or Column Name Be Identified During Query?
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
The system is busy. Please try again later.
For any further questions, feel free to contact us through the chatbot.
Chatbot