-- Conectar ao banco: psql "postgresql://eco_jcweb:Jj32631122%40@localhost:5432/ecogestor"
-- Ou executar: psql -h localhost -p 5432 -U eco_jcweb -d ecogestor

-- Listar todos os usuários com senhas
SELECT 
  id,
  username,
  password,
  name,
  role,
  status,
  email,
  phone,
  city,
  state,
  warehouse_name,
  company_name,
  cnpj,
  created_at
FROM users 
ORDER BY created_at DESC;

-- Listar apenas username e senha (formato simples)
SELECT 
  username,
  password,
  name,
  role
FROM users 
ORDER BY username;

