Use the pg_dump utility in postgresql.
1. to export the database data use .
/usr/local/pgsql/bin/pg_dump [database_name] > filename.dat
2. to export only the schema of the database ./usr/local/pgsql/bin/pg_dump -s [database_name] > schema_filename.sql
NOTE:
/usr/local/pgsql/bin/pg_dump --help
Hello,
I am a student at the university of Bradfordat the department of Computing. In
the labs we use postgeSQL. If it is possible can you please inform me how I can
create .dat files with the information of the tables of the existing database
and a .sql file which will have the tables that are cr
