# Postgres/SQL database to KDB+

**URL:** https://forum.kx.com/t/postgres-sql-database-to-kdb/11559
**Category:** Community Support
**Tags:** kdb-and-q
**Created:** [June 19, 2017, 4:13pm UTC](https://forum.kx.com/t/postgres-sql-database-to-kdb/11559 "2017-06-19T16:13:00Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![rtrader](https://avatars.discourse-cdn.com/v4/letter/r/53a042/32.png) [@rtrader](https://forum.kx.com/u/rtrader)
#### Post date: [June 19, 2017, 4:13pm UTC](https://forum.kx.com/t/postgres-sql-database-to-kdb/11559/1 "2017-06-19T16:13:00Z")

</div>

I understand that one can use OBDC to import a sql database into kdb+ but is there an easier way if you have the tables or entire datbased dumped to a file? eg. if I did a pg\_dump or wrote the sql database to file what would be the easiest way to import to kdb?

---

<div class="post-metadata">

### Author: ![Sean\_Keevey](https://avatars.discourse-cdn.com/v4/letter/s/e36b37/32.png) [@Sean\_Keevey](https://forum.kx.com/u/Sean_Keevey)
#### Post date: [June 23, 2017, 12:23pm UTC](https://forum.kx.com/t/postgres-sql-database-to-kdb/11559/2 "2017-06-23T12:23:00Z")

</div>

Have a look at 0: and 1:

[http://code.kx.com/q/ref/filenumbers/#0-text-files](http://code.kx.com/q/ref/filenumbers/#0-text-files)
