Document Center

    AnalyticDB for PostgreSQL

    • Product Introduction
      • Overview
      • Scenarios and benefits
      • Terms
      • Features and limits
      • Features of AnalyticDB for PostgreSQL V6.0
      • Precautions
    • Specifications and Pricing
      • Instance specifications
      • Pricing
      • Expiration and overdue policy
      • Change the billing method from pay-as-you-go to subscription
    • Quick Start
      • Get started with AnalyticDB for PostgreSQL
      • Create an instance
      • Configure an IP address whitelist for an AnalyticDB for PostgreSQL instance
      • Configure an account
      • Connect to an AnalyticDB for PostgreSQL instance
    • Instances
      • Upgrade instance specifications
      • Enable SQL audit
      • Set alert rules for an AnalyticDB for PostgreSQL instance
      • Restart an AnalyticDB for PostgreSQL instance
      • Configure disk encryption for an AnalyticDB for PostgreSQL instance
      • Network Connection
        • Manage public endpoints
        • Release an Internet IP address
      • Version Management
        • Update minor kernel version of an AnalyticDB for PostgreSQL instance
        • Compatibility comparisons between AnalyticDB for PostgreSQL V4.3 and V6.0
        • Check incompatibility between AnalyticDB for PostgreSQL V4.3 and V6.0
      • Tags
        • Bind tags to an AnalyticDB for PostgreSQL instance
        • Unbind a tag from an AnalyticDB for PostgreSQL instance
        • Filter AnalyticDB for PostgreSQL instances by tag
      • Release an instance
    • Data
      • Manage databases
      • Manage schemas
      • Create and manage tables
      • Define table distribution
      • Define table partitioning
      • Define storage models for tables
      • Manage indexes
      • Manage views
      • Space reclaim
      • Manage materialized views
    • Beginner Developer Guide
      • Data types
      • SQL reference
      • Manage users and permissions
      • Insert, update, delete, and truncate data
      • Use INSERT ON CONFLICT to overwrite data
      • Use MaxCompute foreign tables to access MaxCompute data
      • Use OSS foreign tables to access OSS data
      • Use the COPY or UNLOAD statement to import or export data between OSS foreign tables and local tables
      • Use external tables for federated analytics of external SQL databases
      • Transaction management
      • Manage JSON and JSON-B data
      • Use sort keys in column-oriented tables
      • Use ANALYZE statements to collect statistics on AnalyticDB for PostgreSQL
      • Use the EXPLAIN statement to read a query plan
      • Use resource queues for load management
    • Advanced Developer Guide
      • Use advanced extensions
        • Manage extensions
        • Use the Odyssey compute engine
        • Use HyperLogLog
        • Use PostGIS
        • Use compressed bitmap index
        • Use the uuid-ossp extension
      • Use PL/Java
        • Create and use PL/Java UDFs
        • Use the CREATE LIBRARY statement
      • Use PL/Python
    • Data Access
      • Introduction to data migration and synchronization solutions
      • Use Alibaba Cloud Realtime Compute for Apache Flink to read data from AnalyticDB for PostgreSQL
      • Use a Realtime Compute for Apache Flink cluster to write data to an AnalyticDB for PostgreSQL instance
      • Use Data Integration to migrate and batch synchronize data
      • Use the \COPY command to import or export on-premises data
      • Import or export OSS data by using OSS external tables
      • Use the Client SDK
      • Import data
        • Use DTS to synchronize data from an ApsaraDB RDS for MySQL instance to an AnalyticDB for PostgreSQL instance
        • Synchronize data from a PolarDB for MySQL cluster to an AnalyticDB for PostgreSQL instance
        • Use DTS to synchronize data from an ECS-based user-created MySQL database to an AnalyticDB for PostgreSQL instance
        • Use DTS to synchronize data from a user-created MySQL database connected by a leased line, VPN Gateway, or Smart Access Gateway to an AnalyticDB for PostgreSQL instance
        • Use rds_dbsync to migrate or synchronize data from a MySQL database to an AnalyticDB for PostgreSQL database
        • Use rds_dbsync to migrate or synchronize data from a PostgreSQL database to an AnalyticDB for PostgreSQL database
    • Application Migration
      • Migrate data from a self-managed Greenplum database to an AnalyticDB for PostgreSQL instance
      • Migrate data from a Teradata database to an AnalyticDB for PostgreSQL instance
      • Migrate data from an Oracle database to an AnalyticDB for PostgreSQL instance
      • Migrate data from an Amazon Redshift database to an AnalyticDB for PostgreSQL instance
    • Data Warehouse Development
      • Use DataWorks to schedule ETL tasks of AnalyticDB for PostgreSQL
    • BI Analysis and Visualization
      • BI tools compatible with AnalyticDB for PostgreSQL
      • Connect Alibaba Cloud Quick BI to AnalyticDB for PostgreSQL
      • Use Tableau to connect to AnalyticDB for PostgreSQL
    • GANOS
      • Overview
      • Model
        • Geometry model
        • Raster model
        • Trajectory model
      • Raster SQL Reference
        • Terms
        • Raster creation
          • ST_CreateRast
        • Import and export
          • ST_ImportFrom
          • ST_ExportTo
        • Pyramid operations
          • ST_BuildPyramid
          • ST_DeletePyramid
          • ST_BestPyramidLevel
        • Coordinate system conversion
          • ST_Rast2WorldCoord
          • ST_World2RastCoord
        • Pixel value operations
          • S​T_ClipDimension
          • ST_Clip
          • ST_ClipToRast
          • ST_AddZ
          • ST_MosaicFrom
        • DEM operations
          • ST_Slope
        • Attribute query and update
          • ST_Name
          • ST_SetName
          • ST_MetaData
          • ST_Width
          • ST_Height
          • ST_NumBands
          • ST_Value
          • ST_RasterID
          • ST_CellDepth
          • ST_CellType
          • ST_InterleavingType
          • ST_TopPyramidLevel
          • ST_Extent
          • ST_ConvexHull
          • ST_Envelope
          • ST_Srid
          • ST_SetSrid
          • ST_ScaleX
          • ST_ScaleY
          • ST_SetScale
          • ST_SkewX
          • ST_SkewY
          • ST_SetSkew
          • ST_UpperLeftX
          • ST_UpperLeftY
          • ST_SetUpperLeft
          • ST_PixelWidth
          • ST_PixelHeight
          • ST_Georeference
          • ST_IsGeoreferenced
          • ST_UnGeoreference
          • ST_SetGeoreference
          • ST_NoData
          • ST_SetNoData
          • ST_ColorTable
          • ST_SetColorTable
          • ST_Statistics
          • ST_SetStatistics
          • ST_SummaryStats
          • ST_ColorInterp
          • ST_SetColorInterp
          • ST_Histogram
          • ST_SetHistogram
          • ST_BuildHistogram
          • ST_StatsQuantile
          • ST_Quantile
          • ST_MD5Sum
          • ST_SetMD5Sum
          • ST_XMin
          • ST_YMin
          • ST_XMax
          • ST_YMax
          • ST_ChunkHeight
          • ST_ChunkWidth
          • ST_ChunkBands
          • ST_MetaItems
          • ST_SetMetaData
          • ST_BeginDateTime
          • ST_EndDateTime
          • ST_SetBeginDateTime
          • ST_SetEndDateTime
          • ST_DateTime
          • ST_SetDateTime
        • Operators
          • Equal to operator (=)
          • Greater than operator (>)
          • Less than operator (<)
          • Greater than or equal to operator (>=)
          • Less than or equal to operator (<=)
        • Functions for Identifying Spatial Relationships
          • ST_Intersects
          • ST_Contains
          • ST_ContainsProperly
          • ST_Covers
          • ST_CoveredBy
          • ST_Disjoint
          • ST_overlaps
          • ST_Touches
          • ST_Within
        • Auxiliary functions
          • ST_CheckGPU
          • ST_AKId
          • ST_SetAccessKey
          • ST_SetAKId
          • ST_SetAKSecret
        • Variables
          • ganos.raster.calculate_md5
          • ganos.raster.md5sum_chunk_size
          • ganos.raster.mosaic_must_same_nodata
      • SpatialRef SQL reference
        • ST_SrEqual
        • ST_SrReg
        • ST_SrFromEsriWkt
      • Trajectory SQL reference
        • Basic concepts
        • Constructors
          • Overview
          • ST_makeTrajectory
          • ST_append
        • Edit and process functions
          • ST_Compress
          • ST_CompressSED
          • ST_attrDeduplicate
          • ST_sort
          • ST_deviation
        • Attribute metadata
          • ST_attrDefinition
          • ST_attrSize
          • ST_attrName
          • ST_attrType
          • ST_attrLength
          • ST_attrNullable
        • Event functions
          • ST_addEvent
          • ST_eventTimes
          • ST_eventTime
          • ST_eventTypes
          • ST_eventType
        • Attribute functions
          • ST_startTime
          • ST_endTime
          • ST_trajectorySpatial
          • ST_trajectoryTemporal
          • ST_trajAttrs
          • ST_attrIntMax
          • ST_attrIntMin
          • ST_attrIntAverage
          • ST_attrFloatMax
          • ST_attrFloatMin
          • ST_attrFloatAverage
          • ST_leafType
          • ST_leafCount
          • ST_duration
          • ST_timeAtPoint
          • ST_pointAtTime
          • ST_velocityAtTime
          • ST_accelerationAtTime
          • ST_timeToDistance
          • ST_timeAtDistance
          • ST_cumulativeDistanceAtTime
          • ST_timeAtCumulativeDistance
          • ST_subTrajectory
          • ST_subTrajectorySpatial
          • ST_samplingInterval
          • ST_trajAttrsAsText
          • ST_trajAttrsAsInteger
          • ST_trajAttrsAsDouble
          • ST_trajAttrsAsBool
          • ST_trajAttrsAsTimestamp
          • ST_attrIntFilter
          • ST_attrFloatFilter
          • ST_attrTimestampFilter
          • ST_attrNullFilter
          • ST_attrNotNullFilter
          • ST_trajAttrsMeanMax
        • Functions to process bounding boxes
          • ST_MakeBox
          • ST_MakeBox{Z|T|2D|2DT|3D|3DT}
          • ST_BoxndfToGeom
          • ST_Has{xy|z|t}
          • ST_{X|Y|Z|T}Min
          • ST_{X|Y|Z|T}Max
          • ST_ExpandSpatial
        • Operators to process bounding boxes
          • Basic concepts
          • INTERSECT operators
          • INCLUDE operators
          • INCLUDED operators
        • Spatial relationship judgment
          • ST_intersects
          • ST_equals
          • ST_distanceWithin
        • Spatial processing
          • ST_intersection
          • ST_difference
        • Spatial statistics
          • ST_nearestApproachPoint
          • ST_nearestApproachDistance
        • Spatio-temporal relationship judgment
          • ST_intersects
          • ST_equals
          • ST_distanceWithin
          • ST_durationWithin
          • ST_{Z|T|2D|2DT|3D|3DT}Intersects
          • ST_{2D|2DT|3D|3DT}Intersects_IndexLeft
          • ST_{2D|2DT|3D|3DT}DWithin
          • ST_{2D|2DT|3D|3DT}DWithin_IndexLeft
          • ST_{T|2D|2DT|3D|3DT}Contains
          • ST_{T|2D|2DT|3D|3DT}Within
        • Spatio-temporal processing
          • ST_intersection
        • Spatio-temporal statistics
          • ST_nearestApproachPoint
          • S​T_nearestApproachDistance
        • Distance measurement
          • ST_length
          • ST_euclideanDistance
          • ST_mdistance
        • Similarity analysis
          • ST_lcsSimilarity
          • ST_lcsDistance
          • ST_lcsSubDistance
        • Indexing
          • GiST indexing
          • TrajGiST indexing
        • Variables
          • ganos.trajectory.attr_string_length
      • FAQ
        • Load raster data
        • Load vector data
        • Trajectory FAQ
      • Best practice
        • Trajectory best practices
    • Performance index
      • TPC-C
      • TPC-B
      • TPC-H
    • Best Practices
      • Use pg_stat_activity to analyze and diagnose running PostgreSQL queries
      • Bulk update
      • Optimize query performance
      • Configure scheduled maintenance tasks to clear junk data
      • Pre-process special characters within files to be imported
      • Use HyperLogLog for high-performance multi-dimensional data view
      • How do I diagnose and handle locks?
      • Use a connection pool
      • Use the pg_cron plug-in to configure scheduled tasks
    • FAQ
      • What do I do if I cannot connect to an instance?
      • How to view the data size of a table or a database?
      • How do I obtain technical details about AnalyticDB for PostgreSQL?
      • How do I choose an AnalyticDB for PostgreSQL instance type?
      • How do I clear data on a locked disk?
      • How do I modify parameters?
      • How to enable column-store and compression in AnalyticDB for PostgreSQL?
      • Do I need to execute COPY statements as the superuser user?
      • How do I switch the network type?
      • Mappings between compute node types and compute group types
      • How do I terminate the abnormal execution of an SQL statement?
      • What do I do if an AnalyticDB for PostgreSQL instance fails to be created or remains in the creating state for a long time?
      • How do I join the AnalyticDB for PostgreSQL technical support group on DingTalk?
      • Why am I unable to view the bills for my pay-as-you-go instance? And when can I receive my invoice?
      • How do I view the distribution key and partitions of a table?
    • API Reference
      • List of operations by function
      • Request structure
      • Common parameters
      • Responses
      • Sign signatures
      • Service linked role
      • Use RAM for resource authorization
        • Use RAM for resource authorization
        • Resource types supported by RAM
        • Actions of authorized resources
        • Authentication rules for APIs
      • Instance management
        • CreateDBInstance
        • CreateECSDBInstance
        • DeleteDBInstance
        • DescribeDBInstanceAttribute
        • DescribeDBClusterPerformance
        • DescribeDBInstances
        • DescribeRegions
        • DescribeResourceUsage
        • ModifyDBInstanceConnectionMode
        • ModifyDBInstanceDescription
        • ModifyDBInstanceMaintainTime
        • RestartDBInstance
        • UpgradeDBInstance
        • UpgradeDBVersion
        • DescribeDBInstancePerformance
        • DescribeDBInstanceOnECSAttribute
      • Database management
        • DeleteDatabase
      • Account management
        • CreateAccount
        • DescribeAccounts
        • ModifyAccountDescription
        • ResetAccountPassword
      • Security management
        • DescribeDBInstanceIPArrayList
        • ModifySecurityIps
      • Tag management
        • TagResources
        • ListTagResources
        • UntagResources
      • Log management
        • DescribeSQLCollectorPolicy
        • DescribeSQLLogFiles
        • DescribeSQLLogRecords
        • ModifySQLCollectorPolicy
      • Network management
        • AllocateInstancePublicConnection
        • DescribeDBInstanceNetInfo
        • ModifyDBInstanceNetworkType
        • ReleaseInstancePublicConnection
      • Appendix
        • Error codes
          • Client error codes
          • Server error codes
        • Instance types
        • Performance parameters
        • Instance statuses
 
All Products
Search

This Product

  • This Product
  • All Products

    SDK download

    Document Center

    SDK download

    Last Updated: May 29, 2020

    AnalyticDB for PostgreSQL supports the following SDKs:

    • Java SDK
    • Python SDK

    SDK documentation and download

    Next: Overview

    How helpful was this page?

    What might be the problems?

      More suggestions?

      Thank you! We've received your feedback.
      Free Trial Free Trial