Slt,
Je cherche à faire le dump d'une base Postgresql en recuperant le script de creation des tables,vues... et celui des données.
Merci
Version imprimable
Slt,
Je cherche à faire le dump d'une base Postgresql en recuperant le script de creation des tables,vues... et celui des données.
Merci
Code:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15 To dump a database: $ pg_dump mydb > db.out To reload this database: $ psql -d database -f db.out To dump a database called mydb that contains large objects to a tar file: $ pg_dump -Ft -b mydb > db.tar To reload this database (with large objects) to an existing database called newdb: $ pg_restore -d newdb db.tar
dump de toutes les db
Code:
1
2
3
4
5
6
7
8 To dump all databases: $ pg_dumpall > db.out To reload this database use, for example: $ psql -f db.out template1 (It is not important to which database you connect here since the script file created by pg_dumpall will contain the appropriate commands to create and connect to the saved databases.)