How can I export the schema of a database in PostgreSQL?

If you only want the create tables, then you can do pg_dump -s databasename | awk 'RS=\"\";/CREATE TABLE[^;]*;/'",

You should use something like this pg_dump --schema=your_schema_name db1, for details take a look here",

pg_dump -s databasename -t tablename -U user -h host -p port > tablename.sql\nthis will limit the schema dump to the table "tablename" of "databasename"",

You should take a look at pg_dump:\npg_dump --schema-only databasename\n\nWill dump only the schema to stdout as .sql.\nFor windows, you'll probably want to call pg_dump.exe. I don't have access to a Windows machine but I'm pretty sure from memory that's the command. See if the help works for you too.",

I am running Postgres 9.6 where I had to export a particular schema along with data.\n\nI used the following command:\n\npg_dump.exe -U username -d databasename -n schemaname > C:\\mylocation\\mydumpfilename.dmp\n\n\nIf you want only the schema without data, use the switch s instead of n\n\nBelow is the pg_dump switch list:\n\nC:\\Program Files\\PostgreSQL\\9.6\\bin>pg_dump --help\npg_dump dumps a database as a text file or to other formats.\n\nUsage:\n pg_dump [OPTION]... [DBNAME]\n\nGeneral options:\n -f, --file=FILENAME output file or directory name\n -F, --format=c|d|t|p output file format (custom, directory, tar,\n plain text (default))\n -j, --jobs=NUM use this many parallel jobs to dump\n -v, --verbose verbose mode\n -V, --version output version information, then exit\n -Z, --compress=0-9 compression level for compressed formats\n --lock-wait-timeout=TIMEOUT fail after waiting TIMEOUT for a table lock\n -?, --help show this help, then exit\n\nOptions controlling the output content:\n -a, --data-only dump only the data, not the schema\n -b, --blobs include large objects in dump\n -c, --clean clean (drop) database objects before recreating\n -C, --create include commands to create database in dump\n -E, --encoding=ENCODING dump the data in encoding ENCODING\n -n, --schema=SCHEMA dump the named schema(s) only\n -N, --exclude-schema=SCHEMA do NOT dump the named schema(s)\n -o, --oids include OIDs in dump\n -O, --no-owner skip restoration of object ownership in\n plain-text format\n -s, --schema-only dump only the schema, no data\n -S, --superuser=NAME superuser user name to use in plain-text format\n -t, --table=TABLE dump the named table(s) only\n -T, --exclude-table=TABLE do NOT dump the named table(s)\n -x, --no-privileges do not dump privileges (grant/revoke)\n --binary-upgrade for use by upgrade utilities only\n --column-inserts dump data as INSERT commands with column names\n --disable-dollar-quoting disable dollar quoting, use SQL standard quoting\n --disable-triggers disable triggers during data-only restore\n --enable-row-security enable row security (dump only content user has\n access to)\n --exclude-table-data=TABLE do NOT dump data for the named table(s)\n --if-exists use IF EXISTS when dropping objects\n --inserts dump data as INSERT commands, rather than COPY\n --no-security-labels do not dump security label assignments\n --no-synchronized-snapshots do not use synchronized snapshots in parallel jobs\n --no-tablespaces do not dump tablespace assignments\n --no-unlogged-table-data do not dump unlogged table data\n --quote-all-identifiers quote all identifiers, even if not key words\n --section=SECTION dump named section (pre-data, data, or post-data)\n --serializable-deferrable wait until the dump can run without anomalies\n --snapshot=SNAPSHOT use given snapshot for the dump\n --strict-names require table and/or schema include patterns to\n match at least one entity each\n --use-set-session-authorization\n use SET SESSION AUTHORIZATION commands instead of\n ALTER OWNER commands to set ownership\n\nConnection options:\n -d, --dbname=DBNAME database to dump\n -h, --host=HOSTNAME database server host or socket directory\n -p, --port=PORT database server port number\n -U, --username=NAME connect as specified database user\n -w, --no-password never prompt for password\n -W, --password force password prompt (should happen automatically)\n --role=ROLENAME do SET ROLE before dump\n\nIf no database name is supplied, then the PGDATABASE environment\nvariable value is used.\n\nReport bugs to <[email protected]>.\n",

In Linux you can do like this\n\npg_dump -U postgres -s postgres > exportFile.dmp\n\n\nMaybe it can work in Windows too,\nif not try the same with pg_dump.exe \n\npg_dump.exe -U postgres -s postgres > exportFile.dmp\n",

pg_dump -d <databasename> -h <hostname> -p <port> -n <schemaname> -f <location of the dump file>\n\n\nPlease notice that you have sufficient privilege to access that schema.\nIf you want take backup as specific user add user name in that command preceded by -U ",

For Linux: (data excluded)\n\n\npg_dump -s -t tablename databasename > dump.sql (For a specific table in database)\npg_dump -s databasename > dump.sql (For the entire database)\n",