CODEWITHSUNDEEP
sqldatabasepostgresqldatamodel
J. Chan
J. Chan

Reputation: 71

PostgreSQL (Database/Data Model)

I am new to PostgreSQL and have some questions.

  1. What is the best way to import/export tables with PostgreSQL? I know .csv is one way, but are there any easier methods?

  2. 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.

Upvotes: 0

Views: 505

Answers (2)

smyatkin_max
smyatkin_max

Reputation: 365

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

Import Excel Data into PostgreSQL 9.3

Export Postgres table to CSV file with headings

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

Upvotes: 1

Tom-db
Tom-db

Reputation: 6868

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

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

Upvotes: 0

Related Questions