Help Center > > Developer Guide> SQL Reference> GaussDB(DWS) and Postgres SQL> GaussDB(DWS), PostgreSQL psql, and libpq

GaussDB(DWS), PostgreSQL psql, and libpq

Updated at:Aug 27, 2020 GMT+08:00

GaussDB(DWS) gsql and PostgreSQL psql

GaussDB(DWS) gsql differs from PostgreSQL psql in that the former has made the following changes to enhance security:

  • User passwords cannot be set by running the \password command.
  • The \i+, \ir+, and \include_relative+ commands and the input and output parameter -k are added to encrypt imported and exported files.
  • Historical command lines cannot be printed to files using the \s metacommand.
  • SQL statements related to sensitive operations, such as those containing passwords, are not recorded. Users cannot see such records when they turn pages or press up or down arrow keys to view the SQL history.
  • After a connection is set up, a message is displayed to inform users of password expiration and to show version information.

gsql also has the following functions in addition to psql functions:

  • The output format parameter -r is added. Allows users to adjust the focus by pressing the Tab key or arrow keys when entering commands.
  • The \parallel metacommand is added to improve execution performance.
  • The \set RETRY statement is added to support retry upon statement errors.
  • Slashes (/) are used as default terminators at the end of PL/SQL statements (such as those used for creating or replacing a function or procedure) for convenience.

libpq

During the development of certain GaussDB(DWS) functions, such as the gsql client connection tool, PostgreSQL libpq is greatly modified. However, the libpq interface is not verified in application development scenarios. You are not advised to use this set of interfaces for application development, because underlying risks probably exist. You can use the ODBC or JDBC interface instead.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel