postgresql Archives - Page 6 of 9

PostgreSQL function for last inserted ID

In PostgreSQL, how do I get the last id inserted into a table? In MS SQL there is SCOPE_IDENTITY(). Please do not advise ...

May 8, 2022
0 Comments

Alternate output format for psql

I am using PostgreSQL 8.4 on Ubuntu. I have a table with columns c1 through cN. The columns are wide enough that selecting ...

May 8, 2022
0 Comments

Permission denied for relation

I tried to run simple SQL command: select * from site_adzone; and I got this error ERROR: permission denied for relation site_adzone What ...

May 8, 2022
0 Comments

psql: FATAL: Ident authentication failed for user “postgres”

I have installed PostgreSQL and pgAdminIII on my Ubuntu Karmic box. I am able to use pgAdminIII successfully (i.e. connect/log on), however when ...

May 7, 2022
0 Comments

Where does PostgreSQL store the database?

Where are the files for a PostgreSQL database stored? 14 Answers 14

May 7, 2022
0 Comments

How to log PostgreSQL queries?

How to enable logging of all SQL executed by PostgreSQL 8.3? Edited (more info) I changed these lines : log_directory = 'pg_log' log_filename="postgresql-%Y-%m-%d_%H%M%S.log" ...

May 6, 2022
0 Comments

Restore a postgres backup file using the command line?

I’m new to postgresql, and locally, I use pgadmin3. On the remote server, however, I have no such luxury. I’ve already created the ...

May 6, 2022
0 Comments

List tables in a PostgreSQL schema

When I do a \dt in psql I only get a listing of tables in the current schema (public by default). How can ...

May 6, 2022
0 Comments

What is the format for the PostgreSQL connection string / URL?

What is the format for the PostgreSQL connection string (URL postgres://...) when the host is not the localhost? 6 Answers 6

May 5, 2022
0 Comments

How to export table as CSV with headings on Postgresql?

I’m trying to export a PostgreSQL table with headings to a CSV file via command line, however I get it to export to ...

May 5, 2022
0 Comments