Postgres sample sql file

The pagila-data. Both formats are provided for those who have trouble using one version or another. Skip to content. Star Branches Tags. Could not load branches. Could not load tags. Latest commit. Git stats 29 commits. This has the advantage of being built-in and supporting a scalable data generator. Jump to: navigation , search. MySQL has a popular sample database named Sakila. Sakila has been ported to many databases including Postgres. Pagila is a more idiomatic Postgres port of Sakila.

PgFoundry had a collection of Postgres-compatible sample databases but it has not been updated since No registration required. The result is 68 tables containing HR, sales, product, and purchasing data organized across 5 schemas.

Now execute the SQL file in the terminal window. Confirm there is a database created with some table data that can be used to test the psql command. A role or user for that database will also be required. Following is a brief explanation of each of the options, or flags, used for the psql command that will execute the SQL script file:.

Use This is arguably the most critical of all the options. The final step in this process is to execute the file using the psql command while connecting with an username, host and database. Note that this example uses the objectrocket role.

The following command can be used to access the test. The -a option, also referred to as the --echo-all option, is used to echo, or print, all of the input lines that contain any content.