PostgreSQL (Database/Data Model)

Question

I am new to PostgreSQL and have some questions.

What is the best way to import/export tables with PostgreSQL? I know .csv is one way, but are there any easier methods?
Let's say I have created a data model in Excel, with many tables and relationships... Can I import that data model directly into PostgreSQL? I am also wondering about this for MySQL as well.

Community · Accepted Answer · 2017-05-23 11:51:55Z

1

There is a native way for export/import in psql utility - COPY function:

Also, you can use pg_dump to export data in SQL format as Tommasso said.

CommunityBot

11 silver badge

answered Sep 22, 2015 at 9:25

smyatkin_max

3652 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Tom-db · Accepted Answer · 2015-09-22 09:11:24Z

0

1) The "native" Postgres method is using pg_dump / pg_restore:

2) No, there is not native methods. Maybe with external tools

answered Sep 22, 2015 at 9:11

Tom-db

6,9584 gold badges33 silver badges51 bronze badges