Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Where can I find tutorial files of Postgresql [closed]

Tags:

postgresql

postgresql-9.1

I have installed postgresql on my ubuntu machine using,

apt-get install postgresql-9.1

Now I am reading the manual however could not figure out where the tutorial files (e.g., basics.sql) are.

Where can I find or download them?

like image 414
Sait Avatar asked Apr 17 '14 15:04

Sait

People also ask

Where is PostgreSQL data stored?

All the data needed for a database cluster is stored within the cluster's data directory, commonly referred to as PGDATA (after the name of the environment variable that can be used to define it). A common location for PGDATA is /var/lib/pgsql/data.

How do I check PostgreSQL history?

There's no history in the database itself, if you're using psql you can use "\s" to see your command history there. You can get future queries or other types of operations into the log files by setting log_statement in the postgresql. conf file.

Where are PostgreSQL databases stored Windows?

PostgreSQL for Windows installs the PGDATA directory by default into "C:\Program Files\PostgreSQL\some version\data".

How do I show all databases in PostgreSQL?

Use \l or \l+ in psql to show all databases in the current PostgreSQL server. Use the SELECT statement to query data from the pg_database to get all databases.

Video Answer

1 Answers

They're in the PostgreSQL source distribution:

https://github.com/postgres/postgres/tree/master/src/tutorial

Aside: the latest PostgreSQL is 9.3, not 9.1:

http://www.postgresql.org/docs/current/static/tutorial-sql-intro.html

like image 168
Denis de Bernardy Avatar answered Nov 15 '22 05:11

Denis de Bernardy
Sign in to Comment

Related questions

Apply custom doctrine output walker by default to all queries
Npgsql parameters with NULL value, vb.net
Error requiring pg under rvm with postgres.app
What's the simplest way to include the COUNT of associations in a SQL query?
DBD::Pg::st execute failed: ERROR: syntax error at or near "$1"
PostgreSQL - Update table with subquery from updated table itself
Is there a more elegant way to detect changes in a large SQL table without altering it? [duplicate]
Removing COMMENT ON from all objects in PostgreSQL
How to prevent table from being dropped?
PHP Postgres PDO driver does not support prepared statement?
Sum(Case when) resulting in multiple rows of the selection
Liquibase preconditions not working
Dump a table without sequence table in postgres
How to use array_agg() for varchar[]
SQLAlchemy update PostgreSQL array using merge not work
Inserting with empty values in PostgreSQL causes error
Any alternative to MONTH() and YEAR() functions which are common to both MySQL and PostgreSQL
PostgreSQL delete from parent table only
Find records included in range of numbers (min - max)
Sending array of values to a sql query in ruby?

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!