ETL PostgreSQL data to ClickHouse

Represents the core data storage structures in PostgreSQL, containing rows and columns for storing structured data. Each table defines a specific dataset, such as users, transactions, or products.

Virtual tables that present data from one or more tables through a predefined SQL query. Views allow users to simplify complex queries and restrict access to specific data.

Logical containers that organize and group related database objects, such as tables, views, and functions, within a PostgreSQL database. Schemas help manage permissions and maintain data structure clarity.

Database objects that improve query performance by providing efficient access paths to table data. Indexes are commonly used on columns that are frequently searched or sorted.

Reusable SQL or procedural code blocks that perform operations or calculations on data. Functions can encapsulate business logic and are often used to automate repetitive tasks.

Objects that generate unique numeric values, typically used for auto-incrementing primary keys in tables. Sequences ensure the uniqueness and consistency of identifier fields.

Procedures that are automatically executed in response to specific events on a table or view, such as inserts, updates, or deletes. Triggers are used to enforce data integrity and automate workflows.