# \#postgresql

**URL:** https://discourse.julialang.org/tag/postgresql/345.md

[Latest](https://discourse.julialang.org/latest.md) · [Categories](https://discourse.julialang.org/categories.md) · [Tags](https://discourse.julialang.org/tags.md)

---

## [Easiest and most complete package for PostgreSQL right now (Feb 2022)?](https://discourse.julialang.org/t/easiest-and-most-complete-package-for-postgresql-right-now-feb-2022/75920)

<div class="topic-metadata">

**Author:** [@Ouji](https://discourse.julialang.org/u/Ouji)\
**Replies:** 48\
**Last updated:** [July 11, 2025, 1:52am UTC](https://discourse.julialang.org/t/easiest-and-most-complete-package-for-postgresql-right-now-feb-2022/75920 "2025-07-11T01:52:51Z")

</div>

What is the most straightforward, easiest and most complete package to use for PostgreSQL? This may pertain to documentation quality too. More particularly, it should allow me to also parse SQL/PostgreSQL syntax embedd…

---

## [What package to use for simple SQL query in different types of database](https://discourse.julialang.org/t/what-package-to-use-for-simple-sql-query-in-different-types-of-database/57868)

<div class="topic-metadata">

**Author:** [@Laco\_Kovac](https://discourse.julialang.org/u/Laco_Kovac)\
**Replies:** 13\
**Last updated:** [June 14, 2024, 12:18pm UTC](https://discourse.julialang.org/t/what-package-to-use-for-simple-sql-query-in-different-types-of-database/57868 "2024-06-14T12:18:25Z")

</div>

I need to execute simple SQL (e.g. SELECT \* FROM table) and fetch the returned data, but the database could be 1 of 4 types: PostgreSQL, MySQL, MariaDB and MS SQL Server. Ideally, I would like to use a package which dea…

---

## [Recommend a parsing library for LibPQ.jl?](https://discourse.julialang.org/t/recommend-a-parsing-library-for-libpq-jl/96023)

<div class="topic-metadata">

**Author:** [@iamed2](https://discourse.julialang.org/u/iamed2)\
**Replies:** 1\
**Last updated:** [March 13, 2023, 10:14pm UTC](https://discourse.julialang.org/t/recommend-a-parsing-library-for-libpq-jl/96023 "2023-03-13T22:14:47Z")

</div>

I’m looking to improve the parsing code in LibPQ and expand support for more data types. PCRE2 is expensive and heavyweight, but it’s a challenge to write each parser from scratch and I don’t want to reinvent the wheel. …

---

## [Anyone fetching UUIDs using LibPQ.jl?](https://discourse.julialang.org/t/anyone-fetching-uuids-using-libpq-jl/89395)

<div class="topic-metadata">

**Author:** [@iamed2](https://discourse.julialang.org/u/iamed2)\
**Replies:** 2\
**Last updated:** [October 27, 2022, 8:40pm UTC](https://discourse.julialang.org/t/anyone-fetching-uuids-using-libpq-jl/89395 "2022-10-27T20:40:26Z")

</div>

I’m introducing support for parsing UUIDs from PostgreSQL in LibPQ.jl and I would like to know if anyone would be negatively impacted by setting UUID as the default type for the PostgreSQL uuid type. This means that if y…

---

## [ArgumentError: invalid BigInt: "0E-24" in LibPQ / Decimals](https://discourse.julialang.org/t/argumenterror-invalid-bigint-0e-24-in-libpq-decimals/84790)

<div class="topic-metadata">

**Author:** [@taotree](https://discourse.julialang.org/u/taotree)\
**Replies:** 2\
**Last updated:** [July 26, 2022, 5:19pm UTC](https://discourse.julialang.org/t/argumenterror-invalid-bigint-0e-24-in-libpq-decimals/84790 "2022-07-26T17:19:39Z")

</div>

I’m running a simple SQL select from a table and getting the stacktrace below. I have been using this code for months and today is the first time I’ve seen it so it could be related to me running Pkg.update() recently. F…

---

## [Seeking assistance to INSERT data into Postgres DB using LibPQ.jl](https://discourse.julialang.org/t/seeking-assistance-to-insert-data-into-postgres-db-using-libpq-jl/84510)

<div class="topic-metadata">

**Author:** [@adenoz](https://discourse.julialang.org/u/adenoz)\
**Replies:** 5\
**Last updated:** [July 22, 2022, 4:26am UTC](https://discourse.julialang.org/t/seeking-assistance-to-insert-data-into-postgres-db-using-libpq-jl/84510 "2022-07-22T04:26:22Z")

</div>

Hi, Firstly, I am still learning Julia and my recent attempts to expand into Julia is through testing how to write data into a PostgreSQL database. I have been able to successfully connect to and query data in a PG data…

---

## [Create a PostgreSQL Table from a DataFrame or CSV with Schema Inference](https://discourse.julialang.org/t/create-a-postgresql-table-from-a-dataframe-or-csv-with-schema-inference/77328)

<div class="topic-metadata">

**Author:** [@dliden](https://discourse.julialang.org/u/dliden)\
**Replies:** 2\
**Last updated:** [March 3, 2022, 5:19am UTC](https://discourse.julialang.org/t/create-a-postgresql-table-from-a-dataframe-or-csv-with-schema-inference/77328 "2022-03-03T05:19:03Z")

</div>

I am interested in finding a good method for creating a new table in a PostgreSQL database from a CSV or DataFrame without explicitly identifying the column types, much in the way that the Pandas DataFrame.to\_sql() works…

---

## [What is the currently recommended way to access a postgres database?](https://discourse.julialang.org/t/what-is-the-currently-recommended-way-to-access-a-postgres-database/75862)

<div class="topic-metadata">

**Author:** [@met-j](https://discourse.julialang.org/u/met-j)\
**Replies:** 3\
**Last updated:** [February 23, 2022, 9:03am UTC](https://discourse.julialang.org/t/what-is-the-currently-recommended-way-to-access-a-postgres-database/75862 "2022-02-23T09:03:56Z")

</div>

My search made it look like the LibPQ.jl wrapper would be the most popular way to access a PostgreSQL database. Is there something else I should look at?

---

## [Unable to connect to postgress with libPQ](https://discourse.julialang.org/t/unable-to-connect-to-postgress-with-libpq/70906)

<div class="topic-metadata">

**Author:** [@brett\_knoss](https://discourse.julialang.org/u/brett_knoss)\
**Replies:** 7\
**Last updated:** [November 6, 2021, 12:44am UTC](https://discourse.julialang.org/t/unable-to-connect-to-postgress-with-libpq/70906 "2021-11-06T00:44:26Z")

</div>

conn2 = LibPQ.Connection("dbname=postgres") tells me that I can’t find Unix domain socket "/tmp/.s.PGSQL.5432"? I’m using Ubuntu 20.04.3 LTS on an x86 Xeon machine. I’ve had the same issue with Crystal. Postgress i…

---

## [Not able to load PostgreSQL into LibPQ.jl](https://discourse.julialang.org/t/not-able-to-load-postgresql-into-libpq-jl/68767)

<div class="topic-metadata">

**Author:** [@brett\_knoss](https://discourse.julialang.org/u/brett_knoss)\
**Replies:** 20\
**Last updated:** [September 26, 2021, 3:45am UTC](https://discourse.julialang.org/t/not-able-to-load-postgresql-into-libpq-jl/68767 "2021-09-26T03:45:21Z")

</div>

I have installed postgressql, and am trying to use the LibPQ.jl . But, when I try to connect conn = LibPQ.Connection("dbname=postgres user=BrettKnoss) I’m told that. conn= could not connect to server: No such file or…

---

## [\[ANN\] PostgresORM.jl: Object Relational Mapping for PostgreSQL](https://discourse.julialang.org/t/ann-postgresorm-jl-object-relational-mapping-for-postgresql/63847)

<div class="topic-metadata">

**Author:** [@tencnivel](https://discourse.julialang.org/u/tencnivel)\
**Replies:** 0\
**Last updated:** [June 30, 2021, 5:34pm UTC](https://discourse.julialang.org/t/ann-postgresorm-jl-object-relational-mapping-for-postgresql/63847 "2021-06-30T17:34:32Z")

</div>

I’m happy to announce PostgresORM.jl, a Julia ORM for PostgreSQL. This package was developed to help us create Julia based web applications. Before this public release, it has been used in production for over a year in…

---

## [\[GSoC 2021 PostgreSQL\] 🐘 Create procedural language extension for the Julia programming language](https://discourse.julialang.org/t/gsoc-2021-postgresql-create-procedural-language-extension-for-the-julia-programming-language/56918)

<div class="topic-metadata">

**Author:** [@ImreSamu](https://discourse.julialang.org/u/ImreSamu)\
**Replies:** 5\
**Last updated:** [May 18, 2021, 4:55pm UTC](https://discourse.julialang.org/t/gsoc-2021-postgresql-create-procedural-language-extension-for-the-julia-programming-language/56918 "2021-05-18T16:55:38Z")

</div>

NEWS: The PostgreSQL project has been added a Julia related GSoC 2021 project. (pl/Julia) :elephant: :julia: " Create procedural language extension for the Julia programming language" GSoC 2021 - PostgreSQL wiki “pl/…

---

## [Generating "INSERT INTO" SQL statement](https://discourse.julialang.org/t/generating-insert-into-sql-statement/59106)

<div class="topic-metadata">

**Author:** [@Laco\_Kovac](https://discourse.julialang.org/u/Laco_Kovac)\
**Replies:** 19\
**Last updated:** [April 20, 2021, 1:00pm UTC](https://discourse.julialang.org/t/generating-insert-into-sql-statement/59106 "2021-04-20T13:00:45Z")

</div>

I have either LibPQ.Result or DataFrame as an input, and as output I need to generate SQL statement in the form: INSERT INTO table VALUES (v1,v2,v3), (v4,v5,v6); I cannot use LibPQ.load! because I don’t want to execute…

---

## [How to map Posgres json/jsonb type](https://discourse.julialang.org/t/how-to-map-posgres-json-jsonb-type/52831)

<div class="topic-metadata">

**Author:** [@Laco\_Kovac](https://discourse.julialang.org/u/Laco_Kovac)\
**Replies:** 4\
**Last updated:** [January 5, 2021, 10:06am UTC](https://discourse.julialang.org/t/how-to-map-posgres-json-jsonb-type/52831 "2021-01-05T10:06:07Z")

</div>

I am quite new to Julia and struggling with quite simple task. mutable struct XYZ id::Int64 item::JSON3.Object end To that structure I am trying to add default/empty constructor (setting item to empty JSON3.Object): …

---

## [PL/Julia extension ( minimal )](https://discourse.julialang.org/t/pl-julia-extension-minimal/34232)

<div class="topic-metadata">

**Author:** [@ImreSamu](https://discourse.julialang.org/u/ImreSamu)\
**Replies:** 2\
**Last updated:** [March 15, 2020, 7:07am UTC](https://discourse.julialang.org/t/pl-julia-extension-minimal/34232 "2020-03-15T07:07:54Z")

</div>

" The following is only the beginning of an example to create a new procedural language for PostgreSQL. At some point later we will have something that enables user defined functions and stored procedures written in the J…