Postgres query to check a string is a number

by

I think the easiest way would be a regular expression match:

select '12.41212' ~ '^[0-9\.]+$'
=> true

select 'Service' ~ '^[0-9\.]+$'
=> false

More Related Contents:

  1. What is PostgreSQL equivalent to autoincrement?
  2. How do I specify a password to ‘psql’ non-interactively?
  3. INSERT with dynamic table name in trigger function
  4. psql: FATAL: Ident authentication failed for user “postgres”
  5. How to find table creation time?
  6. What is the format for the PostgreSQL connection string / URL?
  7. Go and IN clause in Postgres
  8. Where does PostgreSQL store the database?
  9. Is there a way to disable function overloading in Postgres
  10. Grant all on a specific schema in the db to a group role in PostgreSQL
  11. Can I make a plpgsql function return an integer without using a variable?
  12. Migrate database from Postgres to MySQL [closed]
  13. How can I start PostgreSQL on Windows?
  14. PostgreSQL – max number of parameters in “IN” clause?
  15. Can’t connect the postgreSQL with psycopg2
  16. How do you change the character encoding of a postgres database?
  17. Difference between GiST and GIN index
  18. Test for null in function with varying parameters
  19. PostgreSQL: Why psql can’t connect to server?
  20. Postgres error on insert – ERROR: invalid byte sequence for encoding “UTF8”: 0x00
  21. Can I use return value of INSERT…RETURNING in another INSERT?
  22. Changing a postgres containers server port in Docker Compose
  23. How do you find the disk size of a Postgres / PostgreSQL table and its indexes
  24. no pg_hba.conf entry for host
  25. PostgreSQL – disabling constraints
  26. PostgreSQL authentication method 10 not supported
  27. Postgres default sort by id – worldship
  28. Best way to install hstore on multiple schemas in a Postgres database?
  29. Loop through columns of RECORD
  30. How to drop PostgreSQL database through command line [closed]

Leave a Comment