postgresql Archives - Page 7 of 9

PostgreSQL: Modify OWNER on all tables simultaneously in PostgreSQL

How do I modify the owner of all tables in a PostgreSQL database? I tried ALTER TABLE * OWNER TO new_owner but it ...

May 4, 2022
0 Comments

How to make “case-insensitive” query in Postgresql?

Is there any way to write case-insensitive queries in PostgreSQL, E.g. I want that following 3 queries return same result. SELECT id FROM ...

May 4, 2022
0 Comments

“use database_name” command in PostgreSQL

I am beginner to PostgreSQL. I want to connect to another database from the query editor of Postgres – like the USE command ...

May 3, 2022
0 Comments

How do you find the row count for all your tables in Postgres

I’m looking for a way to find the row count for all my tables in Postgres. I know I can do this one ...

May 3, 2022
0 Comments

Generating a UUID in Postgres for Insert statement?

My question is rather simple. I’m aware of the concept of a UUID and I want to generate one to refer to each ...

May 3, 2022
0 Comments

Where does PostgreSQL store configuration/conf files?

I have recently installed PostgreSQL on Ubuntu with the EnterpriseDB package. I can connect to the database locally, but I can’t configure it ...

May 3, 2022
0 Comments

How do I specify a password to ‘psql’ non-interactively?

I am trying to automate database creation process with a shell script and one thing I’ve hit a road block with passing a ...

May 3, 2022
0 Comments

How do you create a read-only user in PostgreSQL?

I’d like to create a user in PostgreSQL that can only do SELECTs from a particular database. In MySQL the command would be: ...

May 2, 2022
0 Comments

Postgres: INSERT if does not exist already

I’m using Python to write to a postgres database: sql_string = "INSERT INTO hundred (name,name_slug,status) VALUES (" sql_string += hundred + ", '" ...

May 1, 2022
0 Comments

‘password authentication failed for user “postgres”‘

I have installed PostgreSQL 8.4, Postgres client and Pgadmin 3. Authentication failed for user “postgres” for both console client and Pgadmin. I have ...

May 1, 2022
0 Comments