PSQL Commands References

1. When we connect Postgresql with particular user, if the user is Superuser or has the privilege Create DB , then the prompt will like "=#" otherwise it will look like "=>". 




 2. How to write big queries in psql. 
https://venkataramanapostgresqlreference.blogspot.com/2019/10/how-write-big-queries-in-psql.html


3. How to execute script file in PSQL.
https://venkataramanapostgresqlreference.blogspot.com/2019/10/how-to-execute-script-file-in-psql.html
 

4. How to redirect the output to a text file in PSQL. 
https://venkataramanapostgresqlreference.blogspot.com/2019/10/how-to-redirect-psql-output-to-text-file.html


5. PSQL command to know the details of the table details.
https://venkataramanapostgresqlreference.blogspot.com/2019/10/psql-command-to-know-details-of-table.html

Comments

Post a Comment

Popular posts from this blog

How to connect postgresql database through ODBC driver in excel

Image
Postgresql has ODBC driver " psqlodbc " which will be used to connect to postgresql databases. In this post, we are connecting to postgresql from excel using ODBC driver.  Step1: Verifying the existing ODBC driver in windows (both 32 and 64 bit driver) for availability of postgresql driver.  32-bit driver , we noticed that there is no postgresql driver in the drivers list ( Name column values doesn't start with Postgres text). 64-bit driver , we noticed that there is no postgresql driver in the drivers list ( Name column values doesn't start with Postgres text).  Step2: Checking the current postgresql server version, to get the corresponding psqlodbc driver. As per below screen shot, current version is " 10.10 ". i will try to get and install psqlodbc of 10.10 version. Step3: When check the psqlodbc driver ( https://www.postgresql.org/ftp/odbc/versions/msi/ ), i have found the, psqlodbc_10_3 is the last version that was a...
Read more

Postgresql System files and their uses

Image
The postmaster.opts File This postmaster.opts file sets the default invocation options for the postmaster program, which is the main PostgreSQL program. Typically, it will contain the full path to the postmaster program, a -D option to set the full path to the principal data directory, and optionally, a -i flag to enable network connections. The postmaster.opts options are listed in Table 11-5.  Table 11-5. postmaster Options Option   Description  -B          nbufs Sets the number of shared memory buffers to nbufs. -d           level Sets the level of debug information (level should be a number 1 through 5)               written to the server log. -D dir      Sets the database directory (/data) to dir. There is no default value. If no    ...
Read more