Database Reference
In-Depth Information
Maximum size of a TOAST chunk:
1996
Date/time type storage:
64-bit integers
Float4 argument passing:
by value
Float8 argument passing:
by value
There's more...
Never, ever edit the PostgreSQL control file. If you do, the server probably won't start correctly, or
you may mask other errors. If you do, people will be able to tell, so fess up as soon as possible!!!
List databases on this database server?
When we connect to PostgreSQL, we always connect to just one specific database on any
database server. If there are many databases on a single server, it can get confusing, so
sometimes you just want to find out which databases are part of the database server.
It's also confusing because we can use the word database in two different but related contexts.
Initially, we start off by thinking that PostgreSQL is a "database" in which we put data, referring
to the whole database server just as the word "database". In PostgreSQL, a database server
is potentially split into multiple individual databases, so as you get more used to working with
PostgreSQL, you'll start to separate the two concepts.
Also note that in some other RDBMS, such as SQLServer, the term "database" is more similar
to a "schema" in PostgreSQL.
How to do it...
If you have access to
psql
you can type the following command:
bash $ psql -l
List of databases
Name | Owner | Encoding | Collation | Ctype | Access
privileges
-----------+--------+----------+-------------+-------------+---------
----------
postgres | sriggs | UTF8 | en_GB.UTF-8 | en_GB.UTF-8 |
template0 | sriggs | UTF8 | en_GB.UTF-8 | en_GB.UTF-8 | =c/sriggs
+
| | | | |
sriggs=CTc/sriggs
template1 | sriggs | UTF8 | en_GB.UTF-8 | en_GB.UTF-8 | =c/sriggs
+
| | | | |
sriggs=CTc/sriggs
(3 rows)
