You have got the PATH slightly wrong. You need the PATH to “the containing directory”, not the actual executable itself. Your PATH should be set like this: without the extra sql part in it. Also, you must remove the spaces around the equals sign. Keywords: Postgresql, PATH, macOS, OSX, psql
As the error message tells you – you can not have two rows with the same value in the columns dementia_type, snapid since they need to be unique. You have to make sure that the two databases has the same values for dementia_type, snapid. A workaround would be to add a column to your table alter table t_types_of_dementia add … Read more
Now you have 7 fields. You need to map those 6 fields from the CSV into 6 fields into the table. You cannot map only 3 fields from csv when you have it 6 like you do in: All fields from the csv file need to to be mapped in the copy from command. And … Read more
Use the operating system user postgres to create your database – as long as you haven’t set up a database role with the necessary privileges that corresponds to your operating system user of the same name (h9uest in your case): As recommended here or here. Then try again. Type exit when done with operating as … Read more
localhost as a host refers to a TCP connection, which means the auth method is md5 (password required) per your pg_hba.conf: # IPv4 local connections: host all all 127.0.0.1/32 md5 # IPv6 local connections: host all all ::1/128 md5 For the peer method to be taken, you’d need to connect through Unix domain sockets, and since you seem to be using … Read more
Your function has a couple of smallint parameters.But in the call, you are using numeric literals that are presumed to be type integer. A string literal or string constant (‘123’) is not typed immediately. It remains type “unknown” until assigned or cast explicitly. However, a numeric literal or numeric constant is typed immediately. The manual: A numeric constant that contains neither a decimal … Read more
You have to include the schema if isnt a public one Or you can change your default schema Check your table schema here For example if a table is on the default schema public both this will works ok But sectors need specify the schema
To log in without a password: To reset the password if you have forgotten:
I’ve reinstalled PostgreSQL and now it works.
Restrictions You can ask the system catalog pg_database – accessible from any database in the same database cluster. The tricky part is that CREATE DATABASE can only be executed as a single statement. The manual: CREATE DATABASE cannot be executed inside a transaction block. So it cannot be run directly inside a function or DO … Read more