Pipe&Poof - A Living Journal as IS/IT Techno-functional Practitioner

Article Title

Quick And Fast Way To Import Csv Files Into Postgresql Table For Data Migration Activity

Published Date

27 January 2026 12 AM

Content Length

4 Mins Read.

Short Description

PostgreSQL has GUI based database management tools called pgAdmin. It offer various database management automation tools including automatic csv import and csv export into database schema and tables.

Degananda Ferdian on rdbms

Table of Content

Topics Covered

Background

data formatted with CSV (comma separated value) can be automatically imported into postgresql databases. Each line can be inserted into the tables as long as it has same column length between the schema DDL(data definition language) and csv header.

Objectives

to understand how to bulk insert or import csv data into postgresql databases

Deliverables

Article & Illustration

More on this Category

Degananda Ferdian on cloudflare

24 January 2026 4 Mins Read

Manually Host Javascript Library File On Cloud Flare And Configure The Cors To Allow Script Consumption From Another Website

Cloudflare content delivery network (CDN) hosted approximately 20% of all website that available on the internet. Static files such as html, javascript, markdown, stylesheet can be hosted on cloudflare CDN to ensure fast page load as it can serve all users from the nearest cloudflare server

Degananda Ferdian on git

24 January 2026 9 Mins Read

Create Production Distribution On Github Using Release Tags For Client Side Js Library Hosted Through Cdn

Tags is a checkpoint from source code history on git repostiroy that sliced based on the latest commit on specific target branch. If a checkpoint is taken from release branch, the tags can be considered as production artifact or package distribution

Degananda Ferdian on historian

8 January 2026 9 Mins Read

Key Player On Historian Product As Timeseries Database For Manufacturing And Oil And Gas Indsutry

nowdays OT and IT are slowly emerging and integrated. However, the key vendor for each area remain the same. IT giant like microsoft, google or AWS are not the key player on operation technology area.

Degananda Ferdian on erp

1 January 2026 3 Mins Read

Typical Engineering Simulation Software For Oil And Gas Lng Facilities Operation

Process simulation is done during both FEED and operations phases. Nowdays, the process simulation is done through software and often integrated with historian from control system to get realtime process and event data.

Degananda Ferdian on erp

23 December 2025 5 Mins Read

Maintenance Operations And Asset Management Digital Ecosystem Player On Oil And Gas Upstream Industry

Maintenance operations on complex facilities like oil and gas will definitely require a sets of integrated digital solution (software) including CMMS, EAM, MOC and Competency Management System (CMS)

Degananda Ferdian on short-series

19 December 2025 3 Mins Read

List Of Available And Technically Feasible Text Transformation For Web Design

text transformation on website can be achieved by combining multiple tools including HTML, Javascript and CSS

Degananda Ferdian on short-series

19 December 2025 4 Mins Read

Extracting User Stories From Mockup Or Wireframe Using Frontend Reverse Engineering Method

UI Mockup can be reverse enginereed / deconstructed into small workable divison or screen and some relevant part will be grouped into single user story to ensure small, tangible & independent story.

Prev Next

The Other Side

Pipe & Doodle - UI Template References

About Us

Pipenpoof is techno-functional focused blog and built for sharing our roller coaster journey in software engineering industry as technical and functional role. We documented our experiences during the jobs/projects and our publications will be currated in a series.

All content & publication which are published on this website are subject into writer opinion and point of view (PoV).
None of our contents are related with our current employer or any parties.