RTFM

SET ANSI_PADDING
The SET ANSI_PADDING statement allows the relational interface to handle CHAR data types padded with NULLs (binary zeros). CHAR is defined as a character data type of fixed length.
Pervasive PSQL supports two interfaces: transactional and relational. The transactional interface allows a CHAR to be padded with NULLs. The relational interface conforms to the ANSI standard for padding, which specifies that a CHAR be padded with spaces. For example, by default, a CHAR column created with a CREATE TABLE statement is always padded with spaces.
An application that uses both interfaces may need to process strings padded with NULLs.

Syntax
SET ANSI_PADDING=<ON|OFF>

Да есть такое, до PSQL 9

Notes on Data Types
This section covers various behaviors and key information regarding
the available data types.
CHAR, VARCHAR,
and
LONGVARCHAR
? CHAR columns are padded with blanks to “fill” the columns
? VARCHAR/LONGVARCHAR are not padded with blanks to
“fill” the columns. The significant data is terminated with a
NULL character.
? In all cases the trailing blanks are NOT significant in comparison
operations (LIKE and =). However, in the LIKE case, if a space is
explicitly entered in the query (like 'abc %'), the space before the
wildcard does matter. In this example

Убирай пробелы в запросах функциями RTRIM (string) и LTRIM (string) или
свою встроенную напиши

Зная структуру таблицы пользуйся доступом к ней через DTI