Category "postgresql-9.2"

PostgreSQL ORDER BY with VIEWs

Let's say I want to write a simple SELECT query that uses a VIEW: CREATE TEMP VIEW people AS SELECT p.person_id ,p.full_name ,p.phone FROM person

Postgres equivalent for Oracle's DBA_FREE_SPACE and DBA_DATA_FILES

This is the sql query. I need to convert into postgres query SELECT a.tablespace_name, a.maxbytes, a.mbytes, (a.maxbytes - a.mbytes),

How can I run an ad-hoc script in PostgreSQL?

I'm trying to run this in PostgreSQL 9.2: RAISE NOTICE 'Hello, World!'; And the server says: Error : ERROR: syntax error at or near "RAISE" LINE 1: RAISE NOTI