The solution that will allow you to recover data by performing simple queries to a PostgreSQL database.
Preconditions
You will first receive an email with your login information and necessary information to log into Postgres Appvizer database. This information includes:
- database host,
- database name,
- login information (email/password),
- database port,
- customer dedicated table name.
You will be able to change your password by running a simple request. This will be detailed in the next section. We recommend that you change this password on your first connection and carefully keep this information.
Postgres queries examples
Lead fetch queries
ℹ️ Please note that the access and queries you can perform on the database is limited to the table containing the leads for your company. In addition, you will only have access to it in read mode.
-- recovery of all the data contained in the table
-- email, phone, firstname, fonction, lastname, taille_de_l_entreprise, date
SELECT *
FROM public."<customer dedicated table name>";
-- if you only want to retrieve part of this data, you must specify it as a parameter
-- example: email and date recovery
SELECT email, date
FROM public."<customer dedicated table name>";
-- if you want to sort the data according to one of the columns, you can also do it in ascending (ASC) or descending (DESC) order
-- example: ordered by name in alphabetical order and date from newest to oldest
SELECT *
FROM public."<customer dedicated table name>"
ORDER BY lastname ASC, date DESC;
Change password
In order to ensure that the query works properly, you must be connected to the database with your username and temporary password.
-- modification of your password
ALTER ROLE "<vote_adresse_mail>" PASSWORD '<votre_nouveau_mot_de_passe>'