Say I've created a database in pgAdmin, but I want to export a CREATE sql file.
How would I go about generating the dump?
To generate a sql script that will create the tables as they exist in a given database do:
pg_dump --schema-only --no-owner the_database > create_the_tables.sql
This will give you a bunch of create table statements. Just to see how portable it was I tried the above as follows:
bvm$ pg_dump -s --no-owner devdb | sqlite3 so_ans.db
bvm$ sqlite3 so_ans.db .schema CREATE TABLE courses ( id integer NOT NULL, name text, created_by integer, jc text );
Kind of cool.