Back to Plain format. In pgAdmin we choose a plain format and options as above or use comand line in CMD in folder where pgAdmin was installed as below:
pg_dump.exe --host myhost --port 8035 --username "myuser" --format plain --schema-only --no-owner --no-privileges --verbose --file "filename" "mydbname"
After generating it, in CMD run:
psql -d my-db-name -f "c:\aaa\my-exported-schema-file" -U postgres
It will ask for the password. The tool psql comes bundled with pgAdmin, at least it does in version 1.20.
No comments:
Post a Comment