postgreSQL import support
J
Juniper Hare
PDL competitors supply SQL files for directly building tables and/or inserting records for data delivery.
For example:
For PostgreSQL imports:
Example with mock schema:
-- Step 1: Create a table
CREATE TABLE persons(
id SERIAL PRIMARY KEY,
full_name VARCHAR(100),
email VARCHAR(100),
...
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
-- Step 2: Insert data into the table
INSERT INTO customers (full_name, email) VALUES
('Alice Johnson', 'alice.johnson@example.com'),
('Bob Smith', 'bob.smith@example.com'),
('Charlie Brown', 'charlie.brown@example.com'),
('Dana White', 'dana.white@example.com');