postgres   18837

« earlier    

How to update large tables in PostgreSQL – Codacy
Updating a large table in Postgres is not as straightforward as it seems. If you have a table with hundreds of millions of rows you will find that simple operations, such as adding a column or…
update  large  table  postgres 
3 days ago by cailenm
A Curious Moon - Big Machine
really neat approach to learning postgresql
book  postgres  postgresql  books  learning 
3 days ago by kungfoofool
Re: How to list user accounts?
> Is there a command/option to list all database user accounts in postgres?

>From the psql monitor:


via sql:

SELECT u.usename AS "User name",
u.usesysid AS "User ID",
CASE WHEN u.usesuper AND u.usecreatedb THEN CAST('superuser, create
database' AS pg_catalog.text)
WHEN u.usesuper THEN CAST('superuser' AS pg_catalog.text)
WHEN u.usecreatedb THEN CAST('create database' AS
ELSE CAST('' AS pg_catalog.text)
END AS "Attributes"
FROM pg_catalog.pg_user u

(what psql does behind the scenes when you type \du)
list  show  postgres  postgresql  users 
5 days ago by theskett

« earlier    

related tags

active_record  all  amazon  analytics  analyze  api  app  array  artifactory  aws  backup  blogentries  book  books  brew  browser  buffers  caddy  canned  client  comparison  contact  count  create  crud  cve  data  database  databases  db  dba  deployment  dev  development  devops  docker  each  ecto  elixir  emacs  explain  for  gdpr  generator  google-cloud-platform  graphql  gui  guide  hackernews  heroku  highavailability  homebrew  howto  ifttt  in  java  json  jsonb  kafka  kubernetes  large  learning  list  log  mac  migration  mining  mysql  names  oltp  open-source  opensource  operations  optimization  osx  performance  person  pgsql  phoenix  pocket  postgresql  privacy  programming  python  query  rails  random  rdbms  rds  rest  row  scalability  scalable  scaling  schema  search  security  setup  show  slow  software  sql  ssl  statemachines  statistics  stats  storage  system_how-tos  table  tables  tam  time-series  timeseries  tips  tokindle  tools  toread  trans  transactions  translation  tutorial  tutorials  update  upgrade  users  values  vim  web_app  webapp  window_functions 

Copy this bookmark: