postgreSQL and LibreOffice Base 2017 by Henry Weidman

Author:Henry Weidman
Language: eng
Format: azw3
Tags: Database postgreSQL LibreOffice Base Linux
Publisher: Weidman Enterprises LLC
Published: 2017-05-23T07:00:00+00:00

To backup the classdb database, open a terminal window and type the following commands.

cd sql

pg_dump -f classdbBackup.sql classdb The file classdbBackup.sql will be created.

Database Restore To restore from the backup file, type the following command. This will only recreate the data, tables, procedures, and indexes in a new and empty classdb database.

psql -f classdbBackup.sql

4.1.2. Use \copy

The data records in each table may be backed up using the \copy psql command as shown in the following psql command statements. Note that the tilde character is used as a delimiter because it is least likely to appear in any text in the database. The copy command will create the external files shown in single quotes and write all table records to those files. It is not necessary to create this sql file because this functionality already exists in the Admin.sql file.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.