Skip to main content
Version: 0.8

PostgreSQL

Connect​

GreptimeDB also supports PostgreSQL server protocol! To get started, simply add the -U argument to your command, followed by your username and password. Here's an example:

❯ psql -h localhost -p 4003 -U greptime_user -d public
Password for user greptime_user:
psql (15.2, server 0.1.1)
WARNING: psql major version 15, server major version 0.1.
         Some psql features might not work.
Type "help" for help.

public=>

Note: Be sure to replace greptime_user(username) and greptime_pwd(password) with your own username and password.

Table management​

Please refer to Table Management.

Write data​

Please refer to SQL.

Query data​

Please refer to SQL.

Time zone​

GreptimeDB's PostgreSQL protocol interface follows original PostgreSQL on datatype-timezones.

By default, PostgreSQL uses its server time zone for timestamp. To override, you can set time_zone variable for current session using SQL statement SET TIMEZONE TO '<value>';. The value of time_zone can be any of:

  • A full time zone name, for example America/New_York.
  • A time zone abbreviation, for example PST.
  • Offset to UTC such as +08:00.

You can use SHOW to check the current time zone settings. For example:

SHOW VARIABLES time_zone;
 TIME_ZONE 
-----------
 UTC

Change the session time zone to +1:00:

SET TIMEZONE TO '+1:00'

For information on how the time zone affects data inserts and queries, please refer to the SQL documents in the write data and query data sections.