![]() Start the PostgreSQL interactive terminal Note: the directory and file must be writable by postgresql, Note: the file must be readable by postgresql (make it 755),Ĭopy data from a table to a file (from the psql client)ĬOPY table-name TO '/path/to/filename' DELIMITER 'delimiter' Note: in this case, the dump file is in tar format, the database to restore to is after the -d switch and the table to restore is after the -t switch.Ĭopy data from a file into a table (from the psql client)ĬOPY table-name FROM '/path/to/filename' DELIMITER 'delimiter' ![]() Restore a single table from a dump file pg_restore -v -e -Ft -d database -t tablename dumpfile.tar Restore a database from a dump file pg_restore -Fc database.sql Specify the schema with the table name (if applicable) with pg_dump -t schema.table Pg_dump -Fp -file=filename.sql -n schema -clean database ![]() Pg_dump -Fc -file=database.sql -clean databaseĭump a database, plain text, one schema only (-n) It has more advanced features than any other open source database and scales well with huge datasets and high traffic loads.īy default, PostgreSQL listens on TCP port 5432. PostgreSQL is a robust and powerful open source database.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |