Typing in the command \! pwd will print the current working directory in psql. To change working directory use command \cd <path>; replace <path> with desired path. Eg. Running command \cd /run/mount will change the current working directory to /run/mount. Try changing the your working directory to that containing the file which you want to … Read more
SQL identifiers that are case-sensitive need to be enclosed in double quotes: DROP DATABASE “Ajp”; Not sure if they are properly preserved on Windows if you pass them through the commandline though. You might need to put that into a SQL script and pass the script name to psql. For details on valid identifiers please … Read more
Thanks a lot Craig Ringer, works, finally works! You are my new idool now! The steps are: open the cmd SET PGCLIENTENCODING=utf-8 chcp 65001 psql -h your.ip.addr.ess -U postgres
I just had postgres installed and was not able to run the psql command until I ran the following command in my terminal: export PATH=”/Applications/Postgres.app/Contents/Versions/9.5/bin:$PATH” Now the terminal knows where to find postgres when I use the psql command. Remember to replace the version number ‘9.5’ with your current version.
You can do this via this command in psql: \c db_name usr_name
Change the user to postgres : su – postgres Create User for Postgres (in the shell and NOT with psql) $ createuser testuser Create Database (same) $ createdb testdb Acces the postgres Shell psql ( enter the password for postgressql) Provide the privileges to the postgres user $ alter user testuser with encrypted password ‘qwerty’; … Read more
If you wish to list all tables, you must use: \dt *.* to indicate that you want all tables in all schemas. This will include tables in pg_catalog, the system tables, and those in information_schema. There’s no built-in way to say “all tables in all user-defined schemas”; you can, however, set your search_path to a … Read more
In all schemas: => \dt *.* In a particular schema: => \dt public.* It is possible to use regular expressions with some restrictions \dt (public|s).(s|t) List of relations Schema | Name | Type | Owner ——–+——+——-+——- public | s | table | cpn public | t | table | cpn s | t | table … Read more
You can use EXCEPTION WHEN OTHERS clause: BEGIN do something EXCEPTION WHEN OTHERS THEN handle any exception END; Without some exception a using of this clause is not good idea. The debugging, issue diagnostics can be terrible when you use this pattern. It is strong feature (sometimes necessary), but dangerous! Attention – the entry to, … Read more
Statements end with semicolons. In psql, pressing enter without a semicolon continues the statement onto the next line, adding what you wrote to the query buffer rather than executing it. You will notice that the prompt changes from dbname=> to dbname-> to indicate that you’re on a continuation line. regress=> DROP TABLE sometable regress-> \r … Read more