postgresql: restore db from sql
#Upload the backup .sql file to the server #Execute the following command. root@ubuntu:~# psql -Uadempiere idempiere < /opt/idempiere-server/DBImport/DB3.sql
Category: postgresql
postgresql: update column from another table's column
UPDATE c_order SET po_refernce_no = (SELECT po_refernce_no FROM "Import" WHERE c_order_id = c_order.c_order_id), tracking_number = (SELECT tracking_number FROM "Import" WHERE c_order_id = […]
postgresql: remove single quotes after table import.
After several iterations this one worked for me: UPDATE "Import" SET tracking_number = NULL where tracking_number ='';
pgsql: pgdump authentication
create .pg_pass file on the root folder of the user that will run the pgsql command for example. /root or /user […]
pgsql: list and remove triggers
I want to delete directly on the PgSQL database on my OpenBravo application but it has a los of triggers that prevent […]
pgsql: cannot delete line on table.
This happens when I try to manually delete a record on the Database ERROR: update or delete on table "m_inoutline" violates […]
pgsql: cannot use extract function inside a where clause
For Exmple: AND (date_part('YEAR',fin_finacc_transaction.statementdate) = $P{Año}) or AND ((extract(Year from fin_finacc_transaction.statementdate) LIKE $P{Año}) OR $P{Año} = 'ALL') Neither of these work, […]
postgresql: relevant commands
Connecting to Postgress Shell psql -U postgres -d postgres List Users select * from pg_shadow; usename | usesysid | usecreatedb | usesuper […]
postgresql: not listening
http://stackoverflow.com/questions/12286886/postgresql-server-doesnt-listen ERROR 1 could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "xxx.xxx.xxx.xxx" and accepting TCP/IP connections […]