How do Postgres create a file to populate a bank?

Question

Navigation

#1 by (3 votes)
#2 by (0 votes)

2

I have a database in POSTGRESQL populated, wanted to know if a command exists

SQL that returns a string that has the following command for all existing tables:

INSERT INTO aluno(id , nome, idade ) values(1,'Raul',23)

I wanted to do this to populate another bank that has data similar to the old bank, but has new tables!

sql postgresql tabela

asked by anonymous 15.05.2017 / 14:46

2 answers

0

Use the pg_dump utility:

19.05.2017 / 23:31

score 3 · Accepted Answer

To generate the commands insert of the data it contains in the database you can do the following:

Select Plain format

OntheDumpOptionstab1,select"Data"

OntheDumpOptions2tab,select"User Insert Commands"

IsuggestusingNotepad++toopen